Hyperlink to hidden worksheet

[JoeleneW]

I have a spreadsheet with many tabs, and am trying to keep things simple for
the end users.
Is there a way to hyperlink to or create a button w/macro that goes to a
hidden worksheet?

 

[Jim Cone]

A hyperlink will not work on a hidden sheet.
This code attached to a button shows the sheet "Salaries"...
'--
Sub LetsSeeIt()
Worksheets("Salaries").Visible = True
End Sub
'--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"JoeleneW" <[email protected]>
wrote in message...
I have a spreadsheet with many tabs, and am trying to keep things simple for
the end users.
Is there a way to hyperlink to or create a button w/macro that goes to a
hidden worksheet?