Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi pyrite
The only box I can uncheck appears to be the contents box but unfortunately this makes the whole sheet 'live' for editing text so doesn't really help. Thanks for the try though. Cheers Mark "Pyrite" wrote: I am on 2003 so I dont know if this will be right on 2000 but when protecting the sheet there may be an option to allow cells to be formatted. If there is then select this and you should be good to go. "Mark T UK" wrote: Please help. I have excel 2000. Is it possible to enable an unlocked cell to change font type, size etc in a protected worksheet. The font menu drops down as usual and I can click on a font but it does not change afterwards. Thanks in adavance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
How to change font colour in unlocked cell of protected sheet | Excel Discussion (Misc queries) | |||
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) | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) |