Lock Formulas

  • Thread starter Thread starter kreiss
  • Start date Start date
K

kreiss

How do I look the formulas so users can enter data, but
can't change the formula?

Thanks,
Kacy
 
Hi Kacy,
First, remove the lock possibility from the cells you DO NOT want to lock:
Select those cells, Format, Cells, Protection and remove the check mark.
Second, Tools, Protect sheet, password. This shall prevent people from
changing your formulas but they will be able to input data in the
unprotected cells.

HTH

Gilles Desjardins
 
Back
Top