Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide XL Sheet? (XP)

    Hello,

    I wonder if there's a way in XL to Hide a complete Sheet & then unhide it when you need it?

    BD

  2. #2
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide XL Sheet? (XP)

    SImply Format, Sheet, Hide. And it's hidden. And it's just as simple to unhide it.

    If you want it to be "very hidden", that is, it is hidden in such a way that it cannot be found or seen by the average user, then it must be hidden using macro code.

    In my Navigator Utilities, there is a Sheet utility which, with one click, shows you a list of all the sheets in the workbook, showing which are visible, which are hidden, and which are "very hidden". With Navigator Utilities, it is a simple click to hide or unhide a sheet, or even "very hide" a sheet by holding down the shift key while to click "Hide".

    It also shows which sheets are protected, which are password protected, and easily removes protection if the password has been forgotten. <g>

    regards

Posting Permissions

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