View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_44_] Andrew[_44_] is offline
external usenet poster
 
Posts: 1
Default allowing user to format a protected cell

Hi

When I protect a worksheet, even when a particular cell is unlocked,
users are unable to change the font size, number of decimals in a
calculation, colour of text, bold it, change the width of the colums
etc.

Is there anyway to allow users to make these alterations, while still
protecting other (locked) cells on the same worksheet?

Thanks for your thoughts / advice

andrew.