Hi,

Try this

With Sheets("Sheet1")
.Visible = True
.Select
End With

Mike

"Sri Harsha" wrote:

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.