Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhiding
How do I unhide more than one spreadsheet at once?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhiding
Frisco, you will need to use a macro, something like this,
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 "Frisco, Texas" <Frisco, wrote in message ... How do I unhide more than one spreadsheet at once? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhiding rows automatically | Excel Worksheet Functions | |||
Unhiding Columns | Excel Discussion (Misc queries) | |||
Excel: Enable UnHiding of multiple sheets at once | Excel Discussion (Misc queries) | |||
Unhiding columns | Excel Worksheet Functions | |||
How Do I stop Auto Unhiding Rows? | Excel Worksheet Functions |