| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhide Multiple Sheets
Yiur welcome
"Bev" wrote: Thank you - works like a charm .... "Mike H" wrote: Bev, Right click ant sheet tab, view code and paste this code in. If you run it all hidden sheets become unhidden Sub Sonic() For x = 1 To Worksheets.Count Sheets(x).Visible = True Next End Sub Mike "Bev" wrote: I know you can hide multiple sheets by grouping the sheets and then using the sheet "hide" ... but is there a way to unhide multiple sheets? If you use the same logic as hiding multiple sheets - EXCEL wants you to select which sheet to unhide. Unless I am doing something wrong - it will not permit you to select multiple sheets to unhide. I am using Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide multiple sheets | Excel Discussion (Misc queries) | |||
| Unhide multiple sheets all at once | Excel Discussion (Misc queries) | |||
| Unhide multiple work sheets at once | Excel Worksheet Functions | |||
| Can I unhide multiple sheets at once? | Excel Discussion (Misc queries) | |||
| How do I unhide multiple sheets? | Excel Worksheet Functions | |||
Threaded Mode
