Changing Font in an unlocked cell in a protected sheet.

M

Mark T UK

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.
 
P

Pyrite

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.
 
M

Mark T UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change font colour in unlocked cell of protected sheet 2
Is it possible to protect cell formatting in an unlocked cell? 2
How to change format protection default to unlocked? 2
Locked Several Worksheets, allow format cells/select unlocked cell 2
Bypass unlocked cell on protected worksheet in Excel 2003? 8
How do I create a comment on an unlocked cell in a protected sheet 1
Protected sheets in a excell spreedsheet 1
Entering photos or pdf into a protected sheet 1

Top