Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide Multiple Sheets At One Time? | Excel Discussion (Misc queries) | |||
Unhide multiple work sheets at once | Excel Worksheet Functions | |||
Can I unhide multiple sheets at once? | Excel Discussion (Misc queries) | |||
How do you "Unhide" multiple sheets at one time? | Excel Worksheet Functions | |||
How do I unhide multiple sheets? | Excel Worksheet Functions |