unhide sheets

[Brian Thompson via OfficeKB.com]

Hi

Is there a way of unhiding multiple sheets without the use of VBA. Using the
function under formating only allows one at a time

thanks in advance

regards

 

[Roger Govier]

Hi Brian

Click on first sheet tab, hold down shift and click on last sheet tab if
they are contiguous, or hold Ctrl and click on separate sheets.
This will group them. Format>Sheets>Hide

 

[Dave Peterson]

Roger showed a way to hide sheets.

But you're going to need a macro to unhide more than one at a time.

 

[Jim Cone]

Brian,

The free Excel add-in "Excel Extras" does that and several other things.
It adds a "Unhide All" menu item to the Format | Sheet menu.
You can download it here...
http://www.realezsites.com/bus/primitivesoftware

Regards,
Jim Cone
San Francisco, USA


"Brian Thompson via OfficeKB.com" <u15682@uwe>
wrote in message
Hi
Is there a way of unhiding multiple sheets without the use of VBA.
Using the function under formating only allows one at a time
thanks in advance
regards
--

 

[Brian Thompson via OfficeKB.com]

thanks to you all

Brian,

The free Excel add-in "Excel Extras" does that and several other things.
It adds a "Unhide All" menu item to the Format | Sheet menu.
You can download it here...
http://www.realezsites.com/bus/primitivesoftware

Regards,
Jim Cone
San Francisco, USA

Hi
Is there a way of unhiding multiple sheets without the use of VBA.
Using the function under formating only allows one at a time
thanks in advance
regards