Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HYPERLINK - Jump to another sheet in the same workbook | Excel Worksheet Functions | |||
Hyperlink to Hidden sheet | Excel Programming | |||
how to give hyperlink to hidden excel sheet | Excel Worksheet Functions | |||
Hyperlink to another sheet within a workbook using formula | Excel Worksheet Functions | |||
Hyperlink to another sheet, same workbook | Excel Discussion (Misc queries) |