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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

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

Thanks.. Aman
 
Thi aman,
Please advise how I can create Hyperlink to a hidden sheet in a same
Click to expand...
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
 
Check into the FollowHyperlink Worksheet Event. Once you click the hyperlink
this event could unhide the other sheet.
Mike F
 
Hi Mike,
Check into the FollowHyperlink Worksheet Event.
Click to expand...

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
 
Look at the arguments to followhyperlink. It passes in a reference to the
hyperlink that was clicked.
 
I have tried to use hyperlink in my sheets but when i am sending to others it is not working.

Can you please tell me where is the issue ???

Regards,
Kazim
 
Back
Top