Locking Formulas

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Is there a way to lock formuals in a worksheet so that users can enter new
data without accidently dleleting the formulas?
 
You may unlock the desired cells and then protect the worksheet. See
"protection" in Help.
 
There are two aspects to this:

a. Each cell can be locked or unlocked - this is controlled through
Format | Cells | Protection tab, and the default setting is Locked.

b. The worksheet can be protected (and this can have a password
associated with it) - this is done through Tools | Protection.

The locking of cells only becomes active when the sheet protection has
been applied.

So, what you need to do first is to unlock the cells in which you want
your users to enter data (I usually highlight the cells with a colour
like bright yellow, to make it obvious to the users that that is where
they can enter data). Then you can apply protection to the sheet (with
or without a password), and then you and your users will only be able
to make changes to the cells that have been unlocked.

Hope this helps.

Pete
 
You have replies at your first post.
Is there a way to lock formuals in a worksheet so that users can enter new
data without accidently dleleting the formulas?
Click to expand...
 
Lisa,
Give this a try:
Select all the cells that you want the user to be able to change.
In my case, cells A4 & B4. Select the cells and "Format", and the
"Protection" tab.
"Unlock" the protection on the cells.
Then select "Tools", "Protection","Protect Sheet".
Pick a password that you will be able to remember. Select "OK".
Then re-enter the password.
Save and have fun.

You might want to practice on an unimoprtant worksheet first.
hth
 
Back
Top