That's it! Thanks!
Tabs are now color-coded to content and my obsessive tendencies are satisfied!


"Sean Timmons" wrote:

By shared, he means, if you look at the file name in your title bar does is
say (shared) to the very right?

If so, go to Tools - Share Workbook and remove the checkmark. You'll get a
prompt about saving. Click OK.

"Julianne" wrote:

Originally was shared on a network drive. But downloaded a copy to my own
hard drive and still can't modify tab color.

"Peo Sjoblom" wrote:

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.