| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change font colour in unlocked cell of protected sheet
I have protected a worksheet and unlocked a range of cells for editing but I
cannot change the font colour or fill the colour of these cells though I can write in them. Do you know how to fix this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change font colour in unlocked cell of protected sheet
Hi,
When you protect the sheet ensure you select Allow user to format cells This does apply to both locked and unlocked cells. If you have a problem with that then protect with the above and Allow users to select Unlocked cells unchecked. Mike Mike "Michelle" wrote: I have protected a worksheet and unlocked a range of cells for editing but I cannot change the font colour or fill the colour of these cells though I can write in them. Do you know how to fix this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change font colour in unlocked cell of protected sheet
Unprotect the sheet then re-protect with "Format Cells" enabled under "allow
users to" Gord Dibben MS Excel MVP On Tue, 16 Sep 2008 01:39:01 -0700, Michelle wrote: I have protected a worksheet and unlocked a range of cells for editing but I cannot change the font colour or fill the colour of these cells though I can write in them. Do you know how to fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| formula to change font or cell colour | Excel Worksheet Functions | |||
| Unlocked Cells in Protected Sheet | Excel Worksheet Functions | |||
| How do I create a comment on an unlocked cell in a protected sheet | Excel Discussion (Misc queries) | |||
| change font when sheet is protected | Excel Discussion (Misc queries) | |||
Linear Mode
