Hiding Worksheets

  • Thread starter Thread starter Patti O'Hara
  • Start date Start date
P

Patti O'Hara

How can you unhide several worksheets at one time. I have
worksheets for every month, I want to open all the hidden
worksheets at one time instead of opening them separately.
 
Patti, here is one way

Sub unhide_all_sheets()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Visible = True
Next ws
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 97 & 2000
** remove news from my email address to reply by email **
 
Hi patti
you have to use a macro for this. Enter the following in a module of
your workbook:
Sub Unhide_sheets()
Dim wks As Worksheet

For Each wks In Worksheets
wks.Visible = True
Next wks
End Sub

If you like assign this macro to a toolbar, etc.

Frank
 
Back
Top