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/comm...et.f unctions

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

On Wed, 27 Sep 2006 19:16:02 -0700, Megaptera1969
wrote:

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/comm...et.f unctions

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"

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