protect formulas without password

  • Thread starter Thread starter work
  • Start date Start date
W

work

is there a way i can protect the formulas without protecting and
passwording and identifying various ranges?
the user accidentally enters data into a calculated cell and wipes out
the formula.

thank you,
mike g
 
Mike,

You have to protect the sheet to protect your formulas. You don't have to
use a password. You have to first unlock any cells (Format - Cells -
Protection) that the user will be allowed to change while the sheet is
protected.
 
Back
Top