Unhidding Tabs

[Guest]

Currently in 2003, we can hide tabs en mass by grouping. But when we want to
get a batch back - we have to unhide them individually, the

Format>Tabs>Unhide dialog does not allow for multiple tab selection with

Ctrl or Shift. This is incredibly tedious is large workbooks. I suggestion
this be modified so multiple tabs can be unhidden at one time. Just like we
can do for columns and rows.
Thank you.

----------------
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...-2e8c72951362&dg=microsoft.public.excel.setup

 

[Guest]

.. hide tabs en mass

To unhide tabs en mass, try this sub
(Roger Govier gave it to me 5 years ago)

".. The following will carry out the unhide for all sheets within the
workbook

Sub ShowSheets()
Dim s As Worksheet
For Each s In ActiveWorkbook.Worksheets
s.Visible = True
Next
End Sub

..."

---