+ Reply to Thread
Results 1 to 3 of 3

Hiding worksheet unless selected

  1. #1
    Registered User
    Join Date
    08-17-2006
    Posts
    22

    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)?

  2. #2
    Rich
    Guest

    RE: 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. #3
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    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).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1