Editing the Formulas with VB

[thespardian]

Hi there!
I have a workbooks which contain 24 sheets. I want to disable the formulas on all sheets (All the formula cells should return zero, blanks, error or any other), If the date in sheet1 cell A1< today().

Manual editing the formulas on all sheets required a lot time. Because there are many formula columns on every sheet. Therefore i am seeking for help with vb.

Any help will be highly appreciated.

 

[My Aswer Is This]

So we want to look through all sheets in your workbook. And if the value in Range "A1" of that sheet equals Today. Then all the cells in that sheet should be converted to values not formulas.
Is that correct? Or are you saying clear all the values in any cell that has a formula?

 

[thespardian]

Thanks for your prompt reply.

If the range A1 of sheet1 is less than today, then the formula should return, zero etc (the formula should stop working). but if we manually change/increase the value (If the range A1 of sheet1 is greater than today) , the formula should start working again.