protecting formulas

[Cherilyn]

I am trying to find a way to protect formulas on a spreadsheet whil
still allowing users to put in new data. Is there a way to do this?
am using excel 200

 

[Trevor Shuttleworth]

Cherilyn

unlock the cells where you want input and then protect the sheet with a
password.

Format | Cells... | Protection tab | Locked = false (not ticked)

Regards

Trevor

 

[Cherilyn]

Thanks for the help I can now protect my formulas