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
|