How do I Hyperlink to a hidden sheet in a same workbook ?
 

Hi,

Please advise how I can create Hyperlink to a hidden sheet in a same workbook.

Thanks.. Aman

How do I Hyperlink to a hidden sheet in a same workbook ?
 

Thi aman,

Please advise how I can create Hyperlink to a hidden sheet in a same
workbook.

This will not work with a hyperlink. You need a button, picture or
whatever object on which you can click. When clicked you will need a
macro to unhide your sheet like this (here for a button):

Sub jumptohiddensheet()
Sheets("myHiddenSheet").Visible = True
Application.Goto Reference:="myTargetCell"
End Sub

You can link objects to a macro when you right-click on the object and
select macro. This all is neccessary because I think you cannot link a
macro to a hyperlink.

When you leave the sheet (with a hyperlink or just by clicking on
another sheet) you can hide it with a macro which is an event for the
sheet (do not change the name of the macro):

Private Sub Worksheet_Deactivate()
Sheets("myHiddenSheet").Visible = xlVeryHidden
End Sub


arno

How do I Hyperlink to a hidden sheet in a same workbook ?
 

Check into the FollowHyperlink Worksheet Event. Once you click the hyperlink
this event could unhide the other sheet.
Mike F
"aman" wrote in message
...
Hi,

Please advise how I can create Hyperlink to a hidden sheet in a same
workbook.

Thanks.. Aman

How do I Hyperlink to a hidden sheet in a same workbook ?
 

Hi Mike,

Check into the FollowHyperlink Worksheet Event.

sounds interesting. however, how does this work if I have eg. 5
hyperlinks but only one is pointing to the hidden sheet? So, how do you
know which hyperlink was clicked?

regards
arno

How do I Hyperlink to a hidden sheet in a same workbook ?
 

Look at the arguments to followhyperlink. It passes in a reference to the
hyperlink that was clicked.

--
Regards,
Tom Ogilvy

"arno" wrote in message
...
Hi Mike,

Check into the FollowHyperlink Worksheet Event.

sounds interesting. however, how does this work if I have eg. 5
hyperlinks but only one is pointing to the hidden sheet? So, how do you
know which hyperlink was clicked?

regards
arno