Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Unhide All Worksheets at Once (Excel 2002)

    Is there a way to unhide ALL hidden worksheets at once as opposed to going into Formats/Sheets/Unhide and then unhiding ONE at a time?
    Thanks!
    LJM

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Unhide All Worksheets at Once (Excel 2002)

    In the immediate window in VB you can enter (as one line)

    for each wks in worksheets:wks.visible = true:next

    Or you can add the 3 lines to a routine if you do it often...

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unhide All Worksheets at Once (Excel 2002)

    You could create a macro

    Sub UnHideAll()
    Dim sh As Worksheet
    For Each sh In ActiveWorkbook.Worksheets
    sh.Visible = xlSheetVisible
    Next sh
    Set sh = Nothing
    End Sub

    If you place this macro in a module in Personal.xls, you can call it from every workbook. If you need to do this frequently, you can assign the macro to a custom toolbar button, menu item and/or keyboard shortcut. See Legare Coleman's Personal.xls Tutorial (All) if you need more info.

  4. #4
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Unhide All Worksheets at Once (Excel 2002)

    Thanks to both Steve & Hans for the suggestions & macros! I'm glad to see it wasn't just a command button or menu option I've missed all these years! I'll try not to shock you, but I actually know how to assign a macro to a custom toolbar button, so I should be set there!!
    Thanks again!
    LJM

Posting Permissions

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