Macro Problem

[ccameron]

Hi Guys,
I have a workbook with several sheets, I am hiding all the sheets except for one which is called Directory. I have set up tabs that the user can click on and it should unhide the sheet and stay on that sheet so the user can work on it. The code that I have used seems to unhide the sheet but goes back to the directory sheet. Any ideas on how to solve this problem we be greatly appreciated.

Sub UnhideMIS()
'
' UnhideMIS Macro
'
'
Sheets("Directory").Select
Sheets("MIS").Visible = True
Range("C2:J2").Select
End Sub

Thankyou.

 

[pbornemeier]

You have to select the sheet after you make it visible.

Sheets("MIS").Select

If you want to ensure the cells you mention are visible in the screen, use:

<code>Application.Goto Reference:=Worksheets("MIS").Range("C2"), scroll:=True</code>

 

[ccameron]

Thanks pbornemeier,
I will give it a go