Missing Tab Color Selection in Office 2003 1

[AustinMan]

I am trying to retrieve the Tab Color from Excel 2003.

I can locate the Tab Color Dialog on Format -> Sheet-> Tab Color...; but when you right click on the tab, the tab color selection does not appear.

I have repaired using Detect and Repair, I have reinstalled Office 2003.

I do seem to find the appropriate right context menu name to make it visible using:

Application.CommandBars(name).(control name).visible = True

Does someone have a listing of the right context menu names or an Option I am not seeing. I also have installed Excel 2000 as well. I have Google it as well for the info to no avail.

Thanks for any assistance in advance.

 

[Dreamboat]

So you're not doing this by code, you've just lost that option on the menu, right?

I would troubleshoot in this order:
1. Tools-Customize, toolbars tab, and reset all menus.
(probably won't work)
2. Reset Excel in the registry:
Close Excel.
Start-Run and type "regedit" and go to:
hkey_current_user\software\microsoft\office\11.0\excel

right-click and rename the excel folder to oldexcel

Anne Troy
VBA Coders, please help:

http://www.vbaexpress.com/kb

 

[AustinMan]

Thank you very much, that did the trick.

Thanks for your quick response.

I

 

[Dreamboat]

Sure thing! Now...about that visit to Austin...

Anne Troy
VBA Coders, please help:

http://www.vbaexpress.com/kb

 

[KenWright]

AM - you might want to consider hitting that link at the bottom left of Anne's note:- The one that says

Thank Dreamboat for this valuable post!



Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Dreamboat]

But...but...I wanted the trip to Austin!


Thanks, Ken.

Anne Troy
VBA Coders, please help:

http://www.vbaexpress.com/kb