Tab color problem

K

Kevin B

It sounds as if you're working with a shared workbook. You will need to
unshare the workbook by clicking TOOLS in the menu, selecting SHARE WORKBOOK
and then remove the checkmark from the ALLOW EDITING... check box on the
EDITING tab of the dialog box.
 
S

Shari

I have done that already, and it does not change anything. I do have it
protected, with certain permissions on it. WIll that not let the tab color be
changd?
 
S

Shari

Only problem is....I can't remove protection. It has to stay there. So I am
without color, correct?
 
K

Kevin B

Its WORKBOOK protection that is preventing you from changing tab colors,
Worksheet protection on or off lets you change tab colors.

Can't you remove the WORKBOOK protection, change tab colors and then
re-apply the workbook protection?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab color? 3
Tab color in Excel 2003 2
Change Color of cell 3
Excel 2002: Formating tab color 6
Windows 7 Default page color for e-mail (Outlook) 1
tab color disabled 11
Excel 200 - changing tab colors 1
Nvidia Geforce 347.52 Out, But beware.... 3

Top