ExcelBanter - Locking cell to protect the formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Locking cell to protect the formula (https://www.excelbanter.com/excel-discussion-misc-queries/116408-locking-cell-protect-formula.html)

[email protected]

Locking cell to protect the formula

How can I lock certain cells to protect formula?
Thanks

Bernard Liengme

Locking cell to protect the formula

When you protect a sheet all the cells get locked except those you unlocked
(Format | Cells | Protection) before protecting the sheet
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
How can I lock certain cells to protect formula?
Thanks

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