Hyperlink to hiden sheets

[Mick]

Can I create a hyperlink to go to and display a hidden sheet?
I don't want the sheet accessable as a tab but from a list using a
hyperlink.

Thanks

 

[Guest]

No. Won't work. A hyperlink just (tries) to go to a location, it does not
control the appearance of the location.

My second question would be how are you going to hide that sheet once you DO
get it visible and the person has managed to go to it via some mechanism?

 

[Mick]

It would open as read only, so when they closed it they wouldn't save it,
anyone else opening it would see just the unhidden sheets.

Thanks anyway.

 

[Guest]

You could do all of this through VBA and a macro, but you wouldn't use a
Hyperlink.

From your first post I get the impression that what you want is one sheet in
a workbook to be kind of a Table of Contents sheet with the hyperlinks, some
(or all) leading to hidden sheets, and unfortunately that isn't going to
unhide the sheets.

Wish I had better news for you.