protecting formulas

C

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
 
T

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
 
Top