Locking Formulas


L

Lisa

Is there a way to lock formuals in a worksheet so that users can enter new
data without accidently dleleting the formulas?
 
Ad

Advertisements

B

Bob I

You may unlock the desired cells and then protect the worksheet. See
"protection" in Help.
 
P

Pete_UK

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
 
D

Dave Peterson

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?
 
Ad

Advertisements

F

FloMM2

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
 

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