Thread: How to change font colour in unlocked cell of protected sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote