Cell Protection Issue

[Guest]

Dear All,

I am looking to protect my formula's from accidentally being typed over. I
know that there is the protection, Locked function, but was wondering whether
there is a way to lock some cells completely, and lock others so that they
can be selected but not edited?

Thanks in advance!!

 

[Dave Peterson]

If you lock a cell (Format|cells|protection tab), then protect the worksheet
(tools|protection|Protect sheet), the cell can still be selected, but not
changed.

Did it not work for you?

 

[Guest]

Remember that the Locked status doesn't take effect until the worksheet is
put into Protected state: Tools | Protection | Protect Sheet
In Excel 2003, at that point you have the option to permit users to select
locked cells or not. Selecting a Locked cell on a protected sheet just means
that they can click on it and have it selected, they just can't edit or alter
it. The default is that they can select Locked cells, which as I said, still
doesn't allow them to change what is in them.

On a protected sheet, the only cells they can type information into or copy
from are those you have specifically removed the Locked attribute from using
Format | Cells | [Protection] and cleared the Locked checkbox for.