Unhiding worksheets

[Guest]

Hi,

Can I unhide more than 1 worksheet at a time? Currently I have over 30
hidden sheets, that I have to individually unhide each time I come to use
them.

Thanks

 

[Paul B]

Nic7602, you could use a macro, something like this

Sub UnHide_All_Sheets()

'unhide all sheets in a workbook

Dim sht As Worksheet

For Each sht In ActiveWorkbook.Sheets

sht.Visible = xlSheetVisible

Next

End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Rob]

Try the ASAP utility that has an option of Show all sheets

http://www.asap-utilities.com/