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?



Sukh wrote:

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