Once the user input their amounts into the cell, the formula is gone.
Input and formula need to be on different cell.


KathyHL Wrote:
Is there a way that I can protect the formula in a cell, and its format,
but
still allow a user to change the contents? It's for an expense report.
The
users need to enter their amounts, but the cells have formulas that
need to
be protected.

Thank you!


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390711