Can I unhide multiple sheets at one time?

[Rick J]

I have a spreadsheet that has many sheets - each sheet has weekly financial
data that I enter. For convenience, I hide the sheets that have data
already entered. I originally accomplished this by grouping the filled in
sheets then hiding them all at once using the Format | Sheet | Hide menu
item. When I need to review entered data for a particular week I unhide
that particular sheet. The other day I wanted to unhide all the sheets but
I could only manage to do one at a time from the Format | Sheet | Unhide
menu - ouch, very time consuming. Is there a way to do them all at once?

Thanks,
Rick

 

[Paul B]

Rick, here is one way with a macro

Sub unhide_all_sheets()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Visible = True
Next ws
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Jim Cone]

Rick,

My free Excel add-in "Excel Extras" will do that.
It adds a menu item on the Format menu, next to unhide called "unhide all".
The add-in also does other stuff including sorting sheets in numerical order,
adding a Table of Contents and providing text case options.
Download here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


I have a spreadsheet that has many sheets - each sheet has weekly financial
data that I enter. For convenience, I hide the sheets that have data
already entered. I originally accomplished this by grouping the filled in
sheets then hiding them all at once using the Format | Sheet | Hide menu
item. When I need to review entered data for a particular week I unhide
that particular sheet. The other day I wanted to unhide all the sheets but
I could only manage to do one at a time from the Format | Sheet | Unhide
menu - ouch, very time consuming. Is there a way to do them all at once?
Thanks,
Rick

 

[Rick J]

Paul and Jim - Thanks for the quick response. Jim, I'll check out your
addin.

Rick


|I have a spreadsheet that has many sheets - each sheet has weekly financial
| data that I enter. For convenience, I hide the sheets that have data
| already entered. I originally accomplished this by grouping the filled in
| sheets then hiding them all at once using the Format | Sheet | Hide menu
| item. When I need to review entered data for a particular week I unhide
| that particular sheet. The other day I wanted to unhide all the sheets
but
| I could only manage to do one at a time from the Format | Sheet | Unhide
| menu - ouch, very time consuming. Is there a way to do them all at once?
|
| Thanks,
| Rick
|
|