Dear xld,
i have tried the code you provided but it gives the below warning.
"compile error in hidden module sheet2"

please advice