Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 298
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off hyperlinks in a selected worksheet Jaybird Excel Discussion (Misc queries) 1 April 9th 05 03:04 PM
Protected worksheet, showing and hiding Grouped detail Colin_Bizfine Excel Discussion (Misc queries) 4 April 7th 05 03:44 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Is it possible to copy only selected items to another worksheet... HEATHERCOX Excel Worksheet Functions 2 March 1st 05 01:21 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"