Unhide multiple worksheets in workbook

[Maureen D.]

Hi...I have Excel 2003. Is there a way to unhide multiple worksheets in a
workbook vs. unhiding one at a time?

 

[Don Guillett]

a looping macro

 

[Gord Dibben]

Sub unhide()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Visible = xlHidden Then ws.Visible = xlSheetVisible
Next ws
End Sub


Gord Dibben MS Excel MVP