Help!

Tab's Hide/Show

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup RSS
Next:  3d Pie in Excel 2007  
Author Message
Corey ....
External


Since: Mar 27, 2009
Posts: 2
PostPosted: Fri Mar 27, 2009 12:10 am    Post subject: Tab's Hide/Show
Archived from groups: microsoft>public>excel>setup (more info?)
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....
Back to top
Stefi
External


Since: Mar 06, 2006
Posts: 417
PostPosted: Fri Mar 27, 2009 2:16 am    Post subject: RE: Tab's Hide/Show [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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....
>
>
>
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9178
PostPosted: Fri Mar 27, 2009 3:48 pm    Post subject: Re: Tab's Hide/Show [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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

On Fri, 27 Mar 2009 14:23:46 +1100, "Corey ...." <Corey.RemoveThis@Newsgroups.com.au>
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....
>
Back to top
Corey ....
External


Since: Mar 27, 2009
Posts: 2
PostPosted: Thu Jun 18, 2009 12:10 am    Post subject: Re: Tab's Hide/Show [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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
news:8olqs410spm3gksain3nuhebvlk2jqpb4g@4ax.com...
> 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
>
> On Fri, 27 Mar 2009 14:23:46 +1100, "Corey ...." <Corey.RemoveThis@Newsgroups.com.au>
> 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....
>>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum