Tab Color Issue

H

halper

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


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.
Click to expand...

Gord Dibben MS Excel MVP
 
H

halper

It worked.

Thank you very much.

Gord said:
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




Gord Dibben MS Excel MVP
Click to expand...
 
Top