+ Reply to Thread
Results 1 to 3 of 3

Hiding and unhiding sheets

  1. #1
    D.Hay
    Guest

    Hiding and unhiding sheets

    I want to know how to unhide multiple sheets. I know how to highlight and
    hide multiple sheets, but how do you highlight more than one sheet to unhide
    it. Is that even posible

  2. #2
    Bill Kuunders
    Guest

    Re: Hiding and unhiding sheets

    You'll need to use a macro.

    Sub Macro1()
    For Each Sheet In Sheets
    On Error Resume Next
    Sheet.Visible = True
    Next
    End Sub

    If you need to know how to make the macro work get back to us.


    --
    Greetings from New Zealand
    Bill K
    "D.Hay" <[email protected]> wrote in message
    news:[email protected]...
    >I want to know how to unhide multiple sheets. I know how to highlight and
    > hide multiple sheets, but how do you highlight more than one sheet to
    > unhide
    > it. Is that even posible




  3. #3
    David
    Guest

    Re: Hiding and unhiding sheets

    Bill,
    This macro seems close to what I need. I post a question above wanting to
    hide/expose sheets based on a number either promted from a macro or entered
    into a cell.
    What I'm trying to do is only show the number of technician sheets needed
    for a location. THe workbook comes with 50 technician sheets, but most
    locations have less than 10. I don't want all 50 worksheets to show. I want
    to ask the question, how many techs to you have, only display those number of
    worksheets and hide the rest. Can you give me any help?
    Thanks!

    "Bill Kuunders" wrote:

    > You'll need to use a macro.
    >
    > Sub Macro1()
    > For Each Sheet In Sheets
    > On Error Resume Next
    > Sheet.Visible = True
    > Next
    > End Sub
    >
    > If you need to know how to make the macro work get back to us.
    >
    >
    > --
    > Greetings from New Zealand
    > Bill K
    > "D.Hay" <[email protected]> wrote in message
    > news:[email protected]...
    > >I want to know how to unhide multiple sheets. I know how to highlight and
    > > hide multiple sheets, but how do you highlight more than one sheet to
    > > unhide
    > > it. Is that even posible

    >
    >
    >


+ 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