Change The Tab Color.

K

Kelvin Lee

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

Kelvin Lee

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

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
 
L

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
: >
 
K

Kelvin Lee

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