how do I make a template to lock some information and also allow .

T

tacp1965

I am trying to create a template with information, but lock the info I am
putting in. Also, I want to allow other users to be able to edit the
unlocked cells. How do I do this?
 
D

Dave Peterson

You can unlock the cells that should be changeable by the users.

You can lock the cells that only you can edit.

(By default all the cells are locked.)

So select your range of cells that can be changed.
format|cells|protection tab
uncheck locked.

Now you have to protect the worksheet. (locked cells on an unprotected
worksheet can still be changed)

Tools|protection|protect sheet.

Be aware that this protection can be broken in moments. And there's lots of
stuff that the users won't be able to do. (xl2002+ has a finer level of what
the users can be allowed to do, though.)
 
Top