If you have some cells that have formulas and other cells that have text.
Lock the formula cells and then protect the worksheet.
--
Gary''s Student - gsnu200829


"gems04" wrote:

I have input formulas into 4 worksheets in 1 workbook. For example in
worksheet 1 I have it so D4 automatically populates into D100 and D175, not
only in the 1st worksheet but also in the2nd, 3rd and 4th worksheets. The
problem, maybe with my formula, is if someone where to delet the text in the
2nd worksheet in D100 it'll delete the formula. I need to make sure that if
they delete the text the formula will not be deleted.

Is there a way to make sure that doesn't happen? Or is my formula wrong?

Maria