tab colour can't be changed in 2003 Excel
 

Hi there, I'm trying to change the tab colour in a workbook that was written
by someone else. The sheet is not protected, but when I right click on the
tab the "colour" option is greyed out, so can't be used. I've looked through
the various places in OPTIONS but can't see anything. There must be something
else to look for................
Regards, Brett.

tab colour can't be changed in 2003 Excel
 

You said the Worksheet is not protected, but is the Workbook protected?
TOOLS--PROTECTION--"Unprotect Workbook..."

HTH
Elkar


"Brettjg" wrote:

Hi there, I'm trying to change the tab colour in a workbook that was written
by someone else. The sheet is not protected, but when I right click on the
tab the "colour" option is greyed out, so can't be used. I've looked through
the various places in OPTIONS but can't see anything. There must be something
else to look for................
Regards, Brett.

tab colour can't be changed in 2003 Excel
 

Gotcha. Thanks Elkar

"Elkar" wrote:

You said the Worksheet is not protected, but is the Workbook protected?
TOOLS--PROTECTION--"Unprotect Workbook..."

HTH
Elkar


"Brettjg" wrote:

Hi there, I'm trying to change the tab colour in a workbook that was written
by someone else. The sheet is not protected, but when I right click on the
tab the "colour" option is greyed out, so can't be used. I've looked through
the various places in OPTIONS but can't see anything. There must be something
else to look for................
Regards, Brett.