unhide sheets

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200601/1

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
--
Regards

Roger Govier


"Brian Thompson via OfficeKB.com" <u15682@uwe> wrote in message
news:5a65eb95c956a@uwe...
> 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
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200601/1

Roger showed a way to hide sheets.

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

"Brian Thompson via OfficeKB.com" wrote:
>
> 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
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200601/1

--

Dave Peterson

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
news:5a65eb95c956a@uwe
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
--

thanks to you all

Jim Cone wrote:
>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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200601/1