Hyperlink & Hidden Sheets

[Sridharan]

Hello All,

How do one show the sheet hidden when a user clicks on the hyperlink??? I have four sheets with the first sheet say (Index) containing hyperlinks to the other three sheets(Sheet1, Sheet2, Sheet3) which are hidden. The Index Sheet contains cells with Hyperlinks to these three Sheets. But when the user clicks then the corresponding Hidden Sheet should be Unhidden and shown.

Is that possible???

Thanks for your help

Sridharan

 

[TonyJollans]

Hi Sridharan,

As far as I know, there is no way to attach any code to a hyperlink. An alternative way to achieve what you want would be to use control buttons (to which you can attach code) instead. If you want to, you could probably format them to look like hyperlinks but that's probably going too far.

Add a control button to your index sheet and put code to do whatever you want in its OnClick event. If you want to know exactly how to do this, just ask.

If you want to be able to go Back as you can with a hyperlink you'll need to add buttons to all your worksheets of course (but these will allow you to rehide the sheets).

Enjoy,
Tony

 

[TonyJollans]

It occurred to me after I posted that you might be able to use hyperlinks indirectly by linking to somewhere on your index sheet and picking up the worksheet selection change event and doing what you want to there before going on, but I don't have time to try it at the moment.

Enjoy,
Tony

 

[GlennUK]

In cases like this I use text boxes, formatted to look like a hyperlink, to which I've attached a macro, and get that to do whatever is necessary.

After creating you textbox, simply right click the edge of the box, and choose Assign Macro from the shortcut menu, and point it to your macro for processing.

Glenn.