Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change font colours while protected
How can I let other user's change the font colour without unprotecting sheet.
Regards Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change font colours while protected
While protecting the worksheet Check the Format Cells Check box and enter
your protection password and give ok Alt+T+P+PAllow All User of this Worksheet to:Check the Format Cells check box Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I let other user's change the font colour without unprotecting sheet. Regards Chris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change font colours while protected
I Have excel 2003 and when I enter password and click ok it asks me to
re-enter password. I have tried the tools protect and the format cells on the top of the sheet, am i in the correct place? Thanks Chris "Ms-Exl-Learner" wrote: While protecting the worksheet Check the Format Cells Check box and enter your protection password and give ok Alt+T+P+PAllow All User of this Worksheet to:Check the Format Cells check box Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I let other user's change the font colour without unprotecting sheet. Regards Chris |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change font colours while protected
No you are going in a wrong way, follow the below steps€¦
ToolsProtection select Protect Sheet. A protect sheet Popup Dialogue Box will appear in that you can find two headings: 1) Password to Unprotect Sheet 2) Allow All User of this Worksheet to: In second heading (i.e.) Allow All User of this Worksheet to: check the Format Cells checkbox and enter your protection password in "Password to Unprotect Sheet" give ok then you will be asked to provide the password once again. Enter the same password once again and give ok. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: I Have excel 2003 and when I enter password and click ok it asks me to re-enter password. I have tried the tools protect and the format cells on the top of the sheet, am i in the correct place? Thanks Chris "Ms-Exl-Learner" wrote: While protecting the worksheet Check the Format Cells Check box and enter your protection password and give ok Alt+T+P+PAllow All User of this Worksheet to:Check the Format Cells check box Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I let other user's change the font colour without unprotecting sheet. Regards Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time = say 05:00, how do I change font colours at 15 minute incrim | Excel Discussion (Misc queries) | |||
How to change font colour in unlocked cell of protected sheet | Excel Discussion (Misc queries) | |||
Change font color in protected worksheet | Excel Worksheet Functions | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
change font when sheet is protected | Excel Discussion (Misc queries) |