Unhide multiple sheets all at once

[glenlee]

Is there a way to unhide mutiple sheets all at once? Clicking
Format-Sheet-Unhide, only seems to allow you to choose 1 sheet. I
want to unhide many.

 

[Jim Cone]

There is no built-in method to do that.
You will have to use a macro.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"glenlee"
wrote in message
Is there a way to unhide mutiple sheets all at once? Clicking
Format-Sheet-Unhide, only seems to allow you to choose 1 sheet. I
want to unhide many.

 

[Gord Dibben]

This macro will unhide all sheets.

Sub Show_Sheets()
Dim i As Integer
For i = 1 To ActiveWorkbook.Worksheets.Count
ActiveWorkbook.Worksheets(i).Visible = True
Next i
End Sub


Gord Dibben MS Excel MVP

 

[Guest]

No.

You cannot select more than one worksheet. There is no provison like using
the CTRL key to select more than one or selecting all the hidden worksheet at
once.

Challa prabhu