Tab's Hide/Show
 

Where can i find how to HIDE/SHOW the Tab's in Excel 2007?
I can do this via VBA, but not from the Ribbon or menu's


Corey....

Tab's Hide/Show
 

Right click on the Tab name, Hide is in the local menu.
Regards,
Stefi

€žCorey ....€� ezt Ã*rta:

Where can i find how to HIDE/SHOW the Tab's in Excel 2007?
I can do this via VBA, but not from the Ribbon or menu's


Corey....

Tab's Hide/Show
 

Office ButtonExcel OptionsAdvancedDisplay Options for
this workbookShow sheet tabs.

To actually hide one or more sheets simply select the sheets using CTRL +
Click then right-clickHide.


Gord Dibben MS Excel MVP

On Fri, 27 Mar 2009 14:23:46 +1100, "Corey ...."
wrote:

Where can i find how to HIDE/SHOW the Tab's in Excel 2007?
I can do this via VBA, but not from the Ribbon or menu's


Corey....

Tab's Hide/Show
 

WOW, thanks.

I did not realise the Advanced options had a scroll bar to much much more
options.


p.s better late than never, reply..

Corey....
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Office ButtonExcel OptionsAdvancedDisplay Options for
this workbookShow sheet tabs.

To actually hide one or more sheets simply select the sheets using CTRL +
Click then right-clickHide.


Gord Dibben MS Excel MVP

On Fri, 27 Mar 2009 14:23:46 +1100, "Corey ...."
wrote:

Where can i find how to HIDE/SHOW the Tab's in Excel 2007?
I can do this via VBA, but not from the Ribbon or menu's


Corey....