Change font colours while protected

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

How can I let other user's change the font colour without unprotecting sheet.
Regards
Chris
 
While protecting the worksheet Check the Format Cells Check box and enter
your protection password and give ok

Alt+T+P+P>>Allow All User of this Worksheet to:>>Check the Format Cells
check box

Remember to Click Yes, if this post helps!
 
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
 
No you are going in a wrong way, follow the below steps…

Tools>>Protection>> 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!
 
Back
Top