you need to have an input cell(s) seperate from your formula so instead of
4*2 typed in a cell have 4*A2.Then you cam lock your formula but leave your
input cel unlocked...protect the sheet and your formula will be safe.....
--
paul
remove nospam for email addy!



"Sarah" wrote:

I have created a simple sheet with formulas. I want to protect the formulas
so that if a figure is entered, then deleted, the formular still stays there.
I have tried to use the help menu, but doing the suggested protections makes
it so the figure cant even be entered into the cell! Thank-you for your help!