You have to remove the share under toolsshare workbook and clear the
checkmark from
"allow changes by more than one user etc."

Only other option would be if the workbook is protected but that is less
likely IMO

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
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.