ExcelBanter - How do I freeze a formula so other users can't change it?

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

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

- - How do I freeze a formula so other users can't change it? (https://www.excelbanter.com/excel-discussion-misc-queries/162289-how-do-i-freeze-formula-so-other-users-cant-change.html)

ann

How do I freeze a formula so other users can't change it?

Bernard Liengme

How do I freeze a formula so other users can't change it?

Protect the worksheet after unlocking the cells that the users may change

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Ann" wrote in message
...

All times are GMT +1. The time now is 02:39 AM.