Lock Cells with a Forumlae

[mcp6453]

How can I lock cells in an Excel 2003 template such that cells with
formulae cannot be edited or have data entered into them? Thanks!

 

[Dave Peterson]

Select the cells that should be locked and then use:
format|cells|protection tab|check lock

Select the cells that should be unlocked and uncheck that setting.

Depending on the number of cells of each type, it may be easier to lock (or
unlock) all the cells and just unlock (or lock) the others.

Then you have to protect the worksheet
Tools|Protection|Protect sheet
(give it a nice password)

Be aware that this kind of protection is easily broken and that there are lots
of things that are unavailable on protected sheets.

You may want to do some testing to see it still fits your requirements.

 

[mcp6453]

Thanks, Dave. Simple security is fine. The primary objective is to keep
users from accidentally typing a number over a formula.

 

[Dave Peterson]

When I want this kind of protection, I won't supply a password to the worksheet
protection.

Most(?) users don't know how and won't want to unprotect the sheet.