Unhiding Multiple Sheets

[Fawlty1]

Seems its very easy to hide multiple sheet in a workbook all at once, But is there a way to Unhide Multiple sheets at once or do you have to double click one at a time.

Thanks

 

[BobUmlas]

either one at a time or write a macro...

 

[Tom Urtis]

In answer to your question, you don't have to double click for each sheet, here's a mcro that might do what you want:

Sub UnHideAll()
Dim i
For i = 1 To Sheets.Count
Sheets(i).Visible = True
Next i
End Sub

 

[Fawlty1]

Thanks Tom for the macro, tried it and it worked perfectly.
I'm just surprised that there isn't a "Select All" option when Unhiding Sheets. But I guess that would make sense...