Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding like items from different sheets | Excel Worksheet Functions | |||
Can columns be hidden accross multiple sheets in an Excel workboo | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |