#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 27
Default 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....


  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2,646
Default 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....



  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default 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....


  #4   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 27
Default 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....




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show/Hide series Matt H Charts and Charting in Excel 4 March 14th 08 12:10 PM
Hide/Show Sub data Aaron Excel Discussion (Misc queries) 0 November 30th 07 07:43 PM
can I automatically bring a tab's name into a worksheet? MP Excel Discussion (Misc queries) 4 May 12th 06 03:53 PM
Hide column and show only in row in use Kylie Rose Excel Discussion (Misc queries) 1 January 19th 06 11:22 AM
Hide and show Rows Duane Excel Discussion (Misc queries) 2 April 19th 05 10:50 PM


All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"