Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding worksheet unless selected
Is this possible? I want to hide a bunch of worksheets from the user unless they select it from a hyperlink from Sheet1 (the only one that should initially be visible)? -- SAP PoD ------------------------------------------------------------------------ SAP PoD's Profile: http://www.excelforum.com/member.php...o&userid=37641 View this thread: http://www.excelforum.com/showthread...hreadid=573012 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding worksheet unless selected
befor you save the file, make sure the tabs are removed
tools : options take tick out of sheet tab box ----------------- "SAP PoD" wrote: Is this possible? I want to hide a bunch of worksheets from the user unless they select it from a hyperlink from Sheet1 (the only one that should initially be visible)? -- SAP PoD ------------------------------------------------------------------------ SAP PoD's Profile: http://www.excelforum.com/member.php...o&userid=37641 View this thread: http://www.excelforum.com/showthread...hreadid=573012 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding worksheet unless selected
Unless you want to use VBA code, the users will still be able to see the other sheets if they know how to use Excel (CTRL + Page Up/Down; Format Sheet Unhide). -- jasoncw ------------------------------------------------------------------------ jasoncw's Profile: http://www.excelforum.com/member.php...o&userid=17853 View this thread: http://www.excelforum.com/showthread...hreadid=573012 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off hyperlinks in a selected worksheet | Excel Discussion (Misc queries) | |||
Protected worksheet, showing and hiding Grouped detail | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |