Hyperlink to hiden sheets
 

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

Hyperlink to hiden sheets
 

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" wrote:

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

Hyperlink to hiden sheets
 

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.

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
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" wrote:

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

Hyperlink to hiden sheets
 

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.

"Mick" wrote:

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.

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
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" wrote:

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