P Peterite Nov 24, 2004 #1 Is there a way to unhide multiple sheets at the same time? Thanks for your help!
J JE McGimpsey Nov 24, 2004 #2 One way: Public Sub UnHideAllSheets() Dim wsSheet As Worksheet For Each wsSheet In Worksheets wsSheet.Visible = True Next wsSheet End Sub
One way: Public Sub UnHideAllSheets() Dim wsSheet As Worksheet For Each wsSheet In Worksheets wsSheet.Visible = True Next wsSheet End Sub