How do you protect the formula?

  • Thread starter Thread starter Steverino
  • Start date Start date
S

Steverino

Occationally the person doing the data entry will inadvertantly type
over the formula line and the formular will no longer work. How can I
prevent this? I want the user to be able to change the formular if they
need to, but I don't want it to happen accidentally.

Thank you,
Steve Smith
 
First you will have to unlock the cells you want for data entry. Highlight
the cells reguired. Go to format>cells>protection then uncheck the locked box
Then you will have to Protect the worksheet. Go tools>protection>protect
worksheet. When asked to enter a passwork just click ok. That way no password
will be reguired to unprotect the sheet.
 
Back
Top