How do you protect the formula?

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
 
T

TC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top