It is like what was done in this thread : http://www.mrexcel.com/forum/showthread.php?t=432212
However I want to do the same except with formulas, but I don't want the formulas visible like in the post thread above, where it shows "Type prosthesis here". I only want the formulas to regenerate if what is orignally in the cell is overwritten then deleted.
Example
column
-----A
row 1--=B2*c3
formula in cell A1 = B2*C3 is overwritten intentionally with digit 3, then the user discovers this information is wrong. The user then deletes the digit 3 and then in cell A1 the formula = B2*C3 automatically comes back.
Thanks
However I want to do the same except with formulas, but I don't want the formulas visible like in the post thread above, where it shows "Type prosthesis here". I only want the formulas to regenerate if what is orignally in the cell is overwritten then deleted.
Example
column
-----A
row 1--=B2*c3
formula in cell A1 = B2*C3 is overwritten intentionally with digit 3, then the user discovers this information is wrong. The user then deletes the digit 3 and then in cell A1 the formula = B2*C3 automatically comes back.
Thanks