Hyperlinks to hidden sheets

[Guest]

I have workbook with hidden sheets and I would like to create a hyperlink to
open these sheets when clicked. I know that if they are hidden the hyperlink
will not work. What can I do to make this work?

 

[Dave Peterson]

Maybe you can replace the hyperlink with a macro that unhides the worksheet and
then selects that worksheet.

 

[Guest]

Any direction on how to do this? I have never done that before.

 

[Dave Peterson]

Maybe put a button from the Forms toolbar on a worksheet.
Assign it a macro that looks like:

Option Explicit
Sub testme()
With Worksheets("hiddennamehere")
.Visible = xlSheetVisible
.Select
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm