Unhide multiple sheets all at once

  • Thread starter Thread starter glenlee
  • Start date Start date
G

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.
 
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.
 
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
 
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
 
Back
Top