Unhiding worksheets

P

Plugboy

I am a user of Excel 2000.

A workbook that I update contains 10 worksheets, of which I hide 4 once I
have updated them (on a weekly basis).

Excel allows me to hide all 4 at once, however I have to unhide each sheet
on an individual basis. Is there a way of unhiding all hidden sheets at once?

Thanks.
 
J

Jason Morin

Sub Unhide_All_WS()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = True
Next
End Sub
 
Top