Change The Tab Color.

[Guest]

As per abovemention, how to change the color for the tab, named Sheet1,
Sheet2 and Sheet3 ...

 

[Dave Peterson]

Only possible in xl2002+.

Just rightclick on the tab and choose tab color.

 

[Guest]

Mine is Office 2003. So can I do it?
When I right click my tab, there's no such option.

 

[Dave Peterson]

You sure it's xl2003?

How about:
Format|Sheet|Tab Color
Is that available?

 

[Gord Dibben]

You should have a "Tab Color" option when you right-click a sheet tab with
XL2003

Perhaps your right-click on a tab has been altered.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Ply").Reset


Gord Dibben MS Excel MVP

 

[Lady Layla]

Is the document you are attempting this on a Shared Document? If so, it must be
unshared in order to change the Tab colour


: Mine is Office 2003. So can I do it?
: When I right click my tab, there's no such option.
:
: "Dave Peterson" wrote:
:
: > Only possible in xl2002+.
: >
: > Just rightclick on the tab and choose tab color.
: >
: > Kelvin Lee wrote:
: > >
: > > As per abovemention, how to change the color for the tab, named Sheet1,
: > > Sheet2 and Sheet3 ...
: >
: > --
: >
: > Dave Peterson
: >

 

[Guest]

Now I can change the tab color in Office 2003 already, thanks for all your
helps~ What about in Office 2000?

 

[Dave Peterson]

This was added in xl2002.

Now I can change the tab color in Office 2003 already, thanks for all your
helps~ What about in Office 2000?