"pcconfused" wrote:
can I lock just the formular in a cell

One interp from your subject line ..

Assume there's a formula in C1,
and we want to protect just this cell in the whole sheet

Try this sequence ..

Select entire sheet
Format Cells Protection tab Uncheck "Locked" OK
("unlocks" the entire sheet)

Select cell C1
Format Cells Protection tab Check "Locked" OK
("locks" only cell C1)

Then apply sheet protection via:
Tools Protection Protect Sheet Passwrd? OK

Test it out. All cells on the sheet, other than cell C1,
will be unlocked / unprotected.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--