Unhiding several worksheets

[mcm]

I can hide as many worksheets as I like by highlighting and hiding all
of them. However, when I try to unhide all of them at the same time I
can't and I'm left to unhide them one by one. Is there a way to unhide
several or all hidden woksheets at the same time?

 

[Rafael Ortiz]

Use a macro to do this.

Open the VBA Editor (Alt + F11), then insert a blank VBA module (Insert,
Module), then copy and paste the following VBA code into your module:

Sub dog()
Dim Sheet As Worksheet
For Each Sheet In Worksheets
If Sheet.Visible = False Then
Sheet.Visible = True
End If
Next Sheet
End Sub

Now return to your worksheet area, hit Alt + F8, click and run the macro
called dog, and you should see your result. Just use this macro to unhide
all your hidden sheets in one step.

Let me now if I can help further...

MRO

 

[Scott Hathaway]

Just wanted to add my input too. I've needed to manage worksheets
quickly and the unhiding one at a time is quite time consuming. So to
that end, I created a program that handles those tasks easily. (It's
free...)

Click on http://shsoft.8m.com/worksheetmanager.htm to find out more.

Thanks!
Scott

 

[mcm]

Thanks Scott but your 'free' software keeps opening the file 'worksheet'
manager whenever I activate the icon on my toolbar. I suppose you have
built-in this feature in your VB code. Is there a way to use your
software without having the 'worksheetmanager.xls' file open in a new
excel window?

Cheers