cannot change tab color

  • Thread starter Thread starter Joe Murphy
  • Start date Start date
J

Joe Murphy

Using Excel2003 and tabs whose color were changed cannot be changed back.
When I right-click the tab, Tab Color menu item is grayed out.

The only unusual thing about this spreadsheet is that it is a shared
spreadsheet, but even when the other user closed out Excel and we resaved
theversion of the document on my computer, it still did not allow for the
tab color to be changed.

Thanks,
JM
 
Never mind. I see that a number of settings are disabled when a worksheet is
shared, including changing tab color.
 
Sharing a spreadsheet is a type of protection. So while it is in shared mode
it is essentially protected. To change the tab colour you need to take it out
of shared mode and then make your change. You can then put it back into
shared mode...
 
Back
Top