Hidden Worksheets

Question

I am trying to write a macro in Excel to manipulate Hidden and Visible worksheets and am running into a problem. The Help on this subject reads as follows:

Notes: To select multiple sheets do either of these:

Press and hold CTRL, then click the items to select them.

Press and hold SHIFT, then use the up and down arrow keys to adjust your selection.

Neither of these options work.

My goal here is to select all Hidden sheets and make them visible so I can work with them. Can anyone shed some light on this?

hansvogelaar · Answer

aekbus&nbsp;
You obviously cannot select a hidden sheet.
To unhide all sheets, run this macro:
Sub UnhideAll()
    Dim sh As Object
    Application.ScreenUpdating = False
    For Each sh In Sheets
        sh.Visible = xlSheetVisible
    Next sh
    Application.ScreenUpdating = True
End Sub

aekbus · Answer

Thanks for your reply. That solution is way above my pay grade, but it works!Al

Forum Discussion

Hidden Worksheets

2 Replies