Hi
you can simply protect the cells with formulas. they will
get calculated if the cells referenced by this formula are
changed. So no problem protecting your formula cell.

-----Original Message-----
Hello, i have a worksheet with some formulas in it. I
have the sheet protected, but there are some cells i
cannot protect because if i do, values calculated by
formulas will not populate them. When i leave them
unprotected, there is a risk of people typing their own
value in and erasing the formula. How can i truly
protect
my sheet? I want to alllow data to be populated in
certain cells, but only by formulas, not by a user typing
in whatever they want. Your help greatly appreciated.
.