Tab color problem
 

When I go to change the tab color, it is greyed out. How do I fix this?

Tab color problem
 

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.
--
Kevin Backmann


"Shari" wrote:

When I go to change the tab color, it is greyed out. How do I fix this?

Tab color problem
 

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?

"Kevin B" wrote:

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.
--
Kevin Backmann


"Shari" wrote:

When I go to change the tab color, it is greyed out. How do I fix this?

Tab color problem
 

REmoving protection would be the next thing to do
--
Kevin Backmann


"Shari" wrote:

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?

"Kevin B" wrote:

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.
--
Kevin Backmann


"Shari" wrote:

When I go to change the tab color, it is greyed out. How do I fix this?

Tab color problem
 

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

"Kevin B" wrote:

REmoving protection would be the next thing to do
--
Kevin Backmann


"Shari" wrote:

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?

"Kevin B" wrote:

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.
--
Kevin Backmann


"Shari" wrote:

When I go to change the tab color, it is greyed out. How do I fix this?

Tab color problem
 

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?
--
Kevin Backmann


"Shari" wrote:

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

"Kevin B" wrote:

REmoving protection would be the next thing to do
--
Kevin Backmann


"Shari" wrote:

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?

"Kevin B" wrote:

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.
--
Kevin Backmann


"Shari" wrote:

When I go to change the tab color, it is greyed out. How do I fix this?