LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Changing Font in an unlocked cell in a protected sheet.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
How to change font colour in unlocked cell of protected sheet Michelle Excel Discussion (Misc queries) 2 September 16th 08 05:58 PM
Unlocked Cells in Protected Sheet KMA Excel Worksheet Functions 3 November 8th 07 07:08 PM
How do I create a comment on an unlocked cell in a protected sheet LObeidat Excel Discussion (Misc queries) 1 July 25th 06 01:14 PM
move between unlocked cells on protected sheet ayanna Excel Discussion (Misc queries) 1 April 27th 05 05:59 PM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"