When I right click on a tab in Excell 2003 I used to have the option
for Tab Color and now it is gone. Does anyone know how to restore this
feature? Currently, I have to go into the Format Menubar and select
sheet from there.

Thanks.

View Toolbars Customize Options and press the reset button
--
Gary's Student


" wrote:

When I right click on a tab in Excell 2003 I used to have the option
for Tab Color and now it is gone. Does anyone know how to restore this
feature? Currently, I have to go into the Format Menubar and select
sheet from there.

Thanks.

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 1 Sep 2006 08:09:43 -0700, wrote:

When I right click on a tab in Excell 2003 I used to have the option
for Tab Color and now it is gone. Does anyone know how to restore this
feature? Currently, I have to go into the Format Menubar and select
sheet from there.

Thanks.

Gord Dibben MS Excel MVP

It worked.

Thank you very much.

Gord Dibben wrote:
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 1 Sep 2006 08:09:43 -0700, wrote:

When I right click on a tab in Excell 2003 I used to have the option
for Tab Color and now it is gone. Does anyone know how to restore this
feature? Currently, I have to go into the Format Menubar and select
sheet from there.

Thanks.

Gord Dibben MS Excel MVP