Unhiding worksheets

[Guest]

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.

 

[Frank Kabel]

Hi
you need VBA for this. Or try an addin. e.g.:
http://www.appspro.com/Utilities/ExcelUtilities.htm

 

[Jason Morin]

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