Unhide all sheets

Posted by Rocky Nethercot on November 09, 2001 10:16 AM

Is there any way to unhide all sheets in one,
fell swoop? Sure, you can unhide them one at
a time, but this is a pain when you got 30 to
unhide.

Posted by bob Umlas on November 09, 2001 10:58 AM

Manually, no.
VBA:
For each sh in Sheets:sh.visible=true:next