Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color problem
When I go to change the tab color, it is greyed out. How do I fix this?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem displaying color | Excel Discussion (Misc queries) | |||
Background color problem | Excel Discussion (Misc queries) | |||
Default Border Color Problem | Excel Discussion (Misc queries) | |||
A different "Fill Color" problem | Excel Worksheet Functions | |||
A different "Fill Color" problem | Excel Worksheet Functions |