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

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

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

You sure it's xl2003?

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

Kelvin Lee wrote:

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


--

Dave Peterson

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

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

Application.CommandBars("Ply").Reset


Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 15:21:03 -0800, "Kelvin Lee"
wrote:

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

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


"Kelvin Lee" wrote in message
...
: 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
:

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

"Lady Layla" wrote:

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


"Kelvin Lee" wrote in message
...
: 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
:

This was added in xl2002.

Kelvin Lee wrote:

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

"Lady Layla" wrote:

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


"Kelvin Lee" wrote in message
...
: 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
:




--

Dave Peterson