S
Shari
When I go to change the tab color, it is greyed out. How do I fix this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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?
protected, with certain permissions on it. WIll that not let the tab color be
changd?
K
Kevin B
REmoving protection would be the next thing to do
S
Shari
Only problem is....I can't remove protection. It has to stay there. So I am
without color, correct?
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?
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?