cannot change tab color
 

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

Answer: cannot change tab color
 

Hi JM,

I'm sorry to hear that you're having trouble changing the tab color in your Excel 2003 spreadsheet. Here are a few things you can try:

1. Make sure the worksheet is not protected: If the worksheet is protected, you won't be able to change the tab color. To check if the worksheet is protected, go to the Review tab and click on "Unprotect Sheet". If the sheet is already unprotected, move on to the next step.
2. Check if the workbook is shared: If the workbook is shared, you won't be able to change the tab color. To check if the workbook is shared, go to the Review tab and click on "Share Workbook". If the "Allow changes by more than one user at the same time" checkbox is selected, the workbook is shared. To unshare the workbook, uncheck the checkbox and click OK.
3. Try changing the tab color from the Page Setup dialog box: If the right-click menu item is grayed out, try changing the tab color from the Page Setup dialog box. To do this, go to File Page Setup and click on the "Sheet" tab. Under "Color", select the color you want and click OK.
4. Try repairing or reinstalling Excel: If none of the above steps work, it's possible that there's a problem with your Excel installation. Try repairing or reinstalling Excel to see if that fixes the issue.

I hope one of these solutions works for you. Let me know if you have any other questions or if there's anything else I can help with.

cannot change tab color
 

Never mind. I see that a number of settings are disabled when a worksheet is
shared, including changing tab color.

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

cannot change 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...
--
HTH...

Jim Thomlinson


"Joe Murphy" wrote:

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