Forum Discussion

Brass Contributor

Oct 21, 2024

Hidden Worksheets

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 d...

excel

Macros and VBA

HansVogelaar

MVP

Oct 21, 2024

aekbus

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

Brass Contributor

Oct 21, 2024

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