Tab's Hide/Show

C

Corey ....

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....
 
S

Stefi

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

„Corey ....†ezt írta:
 
G

Gord Dibben

Office Button>Excel Options>Advanced>Display Options for
this workbook>Show sheet tabs.

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


Gord Dibben MS Excel MVP
 
C

Corey ....

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code to create a Word 2013 Ribbon tab which lists recent documents 1
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Hidden Tabs appear when I reopen the file 11
Hide/Reveal ribbons with VBA 2
Excel 2007 Ribbons 2
Page Orientation 1
Access 2007 Ribbon 1
Help with Excel 2007 Ribbon 2

Top