Excel should let me unhide all sheets at once.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

As a frequent user of the Hide Sheet function in Excel with Excel files
generally exceeding ten sheets, the ability to unhide more than 1 hidden
sheet at a time would add tremendous time saving while using the Excel
application.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
While you're waiting for Excel Developers to comply with your request.

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

Note: does not unhide Chart Sheets.


Gord Dibben MS Excel MVP
 
The free Excel add-in "Excel Extras" will do that. It adds a new menu item
underneath the Unhide menu item called "Unhide All."
The program does other stuff including sorting sheets or creating a
table of contents sheet.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA

"Megaptera1969"
<[email protected]>
wrote in message
As a frequent user of the Hide Sheet function in Excel with Excel files
generally exceeding ten sheets, the ability to unhide more than 1 hidden
sheet at a time would add tremendous time saving while using the Excel
application.
----------------
 
Back
Top