| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change font color in protected worksheet
I have a protected worksheet that I would like others to be able to change
font color - but not the information - can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change font color in protected worksheet
Hi Dyanna,
When you protect with the password you have a number of options that you can allow the user to do. Check the boxes for 'Select locked cells' and also 'Format cells'. -- Regards, OssieMac "Dyanna" wrote: I have a protected worksheet that I would like others to be able to change font color - but not the information - can this be done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change font color in protected worksheet
Got it - thanks!!
"OssieMac" wrote: Hi Dyanna, When you protect with the password you have a number of options that you can allow the user to do. Check the boxes for 'Select locked cells' and also 'Format cells'. -- Regards, OssieMac "Dyanna" wrote: I have a protected worksheet that I would like others to be able to change font color - but not the information - can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not able to see font color change. | Excel Discussion (Misc queries) | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| change font when sheet is protected | Excel Discussion (Misc queries) | |||
| How to enable font color on protected worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
