How to create a protected worksheet with formulas?

[MorganH3773]

Hello,

How do I create a protected worksheet with formulas so I can share with other people but make sure they can not change my formulas I have created. How would I go back and chance my formulas too if I needed. Thanks!

Morgan

 

[sadboy309]

You have use Protect Sheet, Protect Workbook, Pass Open File. You can learn more with the keyword above. It can be placed in the Review menu and in windows dialog Save > Tools > General Options....