Protection

M

Mike McLellan

How do I protect certain cells in a sheet so that users can't overwrite
formulae but allow entries in other cells in the same sheet to be edited?
 
D

Dave Peterson

You can lock and unlock cells by selecting them and then
Format|cells|protection tab (xl2003 menus)

But that really doesn't do much until you protect the sheet.

Tools|Protection|protect sheet
(give it a nice password if you want)

Be aware that there are lots of things that are disabled on protected sheets.
You'll want to test to see if you can live with those restrictions.

And don't trust worksheet protection. It's easily broken by anyone who really
wants to break it.
 
Top