Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Any way to unhide multipe sheets without going to FormatSheetUnhide for
EACH sheet individually ? I am talking about a very large number of hidden sheets in multiple workbooks, so a macro would probably not work. Are there any keyboard shortcuts ?? Excel doesn't offer the Shift+click/Ctrl+click selection in the Unhide box. Thank you. |
#2
![]() |
|||
|
|||
![]()
Only using a macro. One way:
Public Sub UnhideAll() Dim ws As Worksheet For Each ws in Worksheets ws.Visible = True Next ws End Sub If you're unfamiliar with macros, see http://www.mvps.org/dmcritchie/excel/getstarted.htm In article , "Juana Cafe" wrote: Any way to unhide multipe sheets without going to FormatSheetUnhide for EACH sheet individually ? I am talking about a very large number of hidden sheets in multiple workbooks, so a macro would probably not work. Are there any keyboard shortcuts ?? Excel doesn't offer the Shift+click/Ctrl+click selection in the Unhide box. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why can i no longer protect multiple worksheets in Excel | Excel Worksheet Functions | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
How to change the footer only, on multiple worksheets in Excel? | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel |