ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab Color Issue (https://www.excelbanter.com/excel-discussion-misc-queries/108121-tab-color-issue.html)

[email protected]

Tab Color Issue
 
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.


Gary''s Student

Tab Color Issue
 
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.



Gord Dibben

Tab Color Issue
 
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

[email protected]

Tab Color Issue
 
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




All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com