Hi

You need to activate the sheet like this once it's unhidden:

Sheets("Sheet1").Acitvate

Hopes this helps

--
Per

"Sri Harsha" skrev i meddelelsen
...
I have recorded a macro that unhides a sheet from the existing workbook.
But
when i run it now, it unhides but remains in the existing sheet. I want it
to
take me to the sheet that has been unhidden.

Pls help.