Hyperlinks to hidden sheets
 

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?

Hyperlinks to hidden sheets
 

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

Aggie G wrote:

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

Hyperlinks to hidden sheets
 

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

"Dave Peterson" wrote:

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

Aggie G wrote:

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

Hyperlinks to hidden sheets
 

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

Aggie G wrote:

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

"Dave Peterson" wrote:

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

Aggie G wrote:

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


--

Dave Peterson