software

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:
gt;
gt; As per abovemention, how to change the color for the tab, named Sheet1,
gt; 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.

quot;Dave Petersonquot; wrote:

gt; Only possible in xl2002 .
gt;
gt; Just rightclick on the tab and choose tab color.
gt;
gt; Kelvin Lee wrote:
gt; gt;
gt; gt; As per abovemention, how to change the color for the tab, named Sheet1,
gt; gt; Sheet2 and Sheet3 ...
gt;
gt; --
gt;
gt; Dave Peterson
gt;

You sure it's xl2003?

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

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

--

Dave Peterson

You should have a quot;Tab Colorquot; 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 Viewgt;Immediate Window.

Copy/paste this line into the window and hit lt;entergt;

Application.CommandBars(quot;Plyquot;).ResetGord Dibben MS Excel MVP

On Wed, 11 Jan 2006 15:21:03 -0800, quot;Kelvin Leequot;
gt; wrote:

gt;Mine is Office 2003. So can I do it?
gt;When I right click my tab, there's no such option.
gt;
gt;quot;Dave Petersonquot; wrote:
gt;
gt;gt; Only possible in xl2002 .
gt;gt;
gt;gt; Just rightclick on the tab and choose tab color.
gt;gt;
gt;gt; Kelvin Lee wrote:
gt;gt; gt;
gt;gt; gt; As per abovemention, how to change the color for the tab, named Sheet1,
gt;gt; gt; Sheet2 and Sheet3 ...
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Dave Peterson
gt;gt;Is the document you are attempting this on a Shared Document? If so, it must be
unshared in order to change the Tab colourquot;Kelvin Leequot; gt; wrote in message
...
: Mine is Office 2003. So can I do it?
: When I right click my tab, there's no such option.
:
: quot;Dave Petersonquot; wrote:
:
: gt; Only possible in xl2002 .
: gt;
: gt; Just rightclick on the tab and choose tab color.
: gt;
: gt; Kelvin Lee wrote:
: gt; gt;
: gt; gt; As per abovemention, how to change the color for the tab, named Sheet1,
: gt; gt; Sheet2 and Sheet3 ...
: gt;
: gt; --
: gt;
: gt; Dave Peterson
: gt;
Now I can change the tab color in Office 2003 already, thanks for all your
helps~ What about in Office 2000?

quot;Lady Laylaquot; wrote:

gt; Is the document you are attempting this on a Shared Document? If so, it must be
gt; unshared in order to change the Tab colour
gt;
gt;
gt; quot;Kelvin Leequot; gt; wrote in message
gt; ...
gt; : Mine is Office 2003. So can I do it?
gt; : When I right click my tab, there's no such option.
gt; :
gt; : quot;Dave Petersonquot; wrote:
gt; :
gt; : gt; Only possible in xl2002 .
gt; : gt;
gt; : gt; Just rightclick on the tab and choose tab color.
gt; : gt;
gt; : gt; Kelvin Lee wrote:
gt; : gt; gt;
gt; : gt; gt; As per abovemention, how to change the color for the tab, named Sheet1,
gt; : gt; gt; Sheet2 and Sheet3 ...
gt; : gt;
gt; : gt; --
gt; : gt;
gt; : gt; Dave Peterson
gt; : gt;
gt;
gt;
gt;

This was added in xl2002.

Kelvin Lee wrote:
gt;
gt; Now I can change the tab color in Office 2003 already, thanks for all your
gt; helps~ What about in Office 2000?
gt;
gt; quot;Lady Laylaquot; wrote:
gt;
gt; gt; Is the document you are attempting this on a Shared Document? If so, it must be
gt; gt; unshared in order to change the Tab colour
gt; gt;
gt; gt;
gt; gt; quot;Kelvin Leequot; gt; wrote in message
gt; gt; ...
gt; gt; : Mine is Office 2003. So can I do it?
gt; gt; : When I right click my tab, there's no such option.
gt; gt; :
gt; gt; : quot;Dave Petersonquot; wrote:
gt; gt; :
gt; gt; : gt; Only possible in xl2002 .
gt; gt; : gt;
gt; gt; : gt; Just rightclick on the tab and choose tab color.
gt; gt; : gt;
gt; gt; : gt; Kelvin Lee wrote:
gt; gt; : gt; gt;
gt; gt; : gt; gt; As per abovemention, how to change the color for the tab, named Sheet1,
gt; gt; : gt; gt; Sheet2 and Sheet3 ...
gt; gt; : gt;
gt; gt; : gt; --
gt; gt; : gt;
gt; gt; : gt; Dave Peterson
gt; gt; : gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson