Unhide multiple sheets all at once
 

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.

Unhide multiple sheets all at once
 

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.

Unhide multiple sheets all at once
 

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

On Sat, 11 Aug 2007 00:52:43 GMT, (glenlee) wrote:

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.

Unhide multiple sheets all at once
 

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

"glenlee" wrote:

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.