View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Locking content, formula, and format in a cell

While content and formula are treated the same, you can format cells -
protections, and uncheck the locked checkbox for specific cells. Then, goto
to Tools-Protection-Protect sheet, you'll see various options that can
control whether users can edit the format of the cells or not.

Note: Under the cell format - protection tab, checking the "hidden" option
will make it so that the formula is not visible when sheet is protected.

--
Best Regards,

Luke M
"Jess" wrote in message
...
Is there anyway to lock the content, format, and formula -separately or
jointly- of a given cell? If so, how