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

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

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