software

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--
Steverino
------------------------------------------------------------------------
Steverino's Profile: www.excelforum.com/member.php...oamp;userid=30851
View this thread: www.excelforum.com/showthread...hreadid=505194First you will have to unlock the cells you want for data entry. Highlight
the cells reguired. Go to formatgt;cellsgt;protection then uncheck the locked box
Then you will have to Protect the worksheet. Go toolsgt;protectiongt;protect
worksheet. When asked to enter a passwork just click ok. That way no password
will be reguired to unprotect the sheet.

quot;Steverinoquot; wrote:

gt;
gt; Occationally the person doing the data entry will inadvertantly type
gt; over the formula line and the formular will no longer work. How can I
gt; prevent this? I want the user to be able to change the formular if they
gt; need to, but I don't want it to happen accidentally.
gt;
gt; Thank you,
gt; Steve Smith
gt;
gt;
gt; --
gt; Steverino
gt; ------------------------------------------------------------------------
gt; Steverino's Profile: www.excelforum.com/member.php...oamp;userid=30851
gt; View this thread: www.excelforum.com/showthread...hreadid=505194
gt;
gt;