You can always just copy the entire worksheet and paste into a new workbook.
This will get aroudn all the craziness...

"Julianne" wrote:

You and Peo Sjoblom are onto the problem, I believe, the only option
available under menu item 'Protection' is 'Protect Shared Workbook'
I think I'm ready to accept that I can't change the tab color and move on.

Thanks very much for your help!


"Sean Timmons" wrote:

Go To Tools - Protection.

If any of them say unprotect, you have protection on. Click on that option
to unprotect it.

Alternately, therer could be some sort of Macro or VB in the background, but
I don't even want to venture into that territory in the event that it could
od more harm than good.

"Julianne" wrote:

I don't know how to determine if my workbook is protected.

"Sean Timmons" wrote:

Is the workbook protected?

"Julianne" wrote:

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.