Set Status bar back to "Ready"

[Steven]

I have a file where the Calculation is set to Manual and I am doing
ActiveSheet.Calculate on a change. Because of this, after the
ActiveSheet.Calculate the Status Bar will show: "Ready
Calculate".

How do I set it back to just "Ready" in the macro code?

Thank you,

Steven

 

[Mike H]

Steven,

With calculation set to manual the 'Calculate' in the statusbar indicates
the worksheet needs to calculate because it isn't up to date. Try it by
making a change in a formula dependent cell and tapping F9 and see if it
clears

Running application.calculate from code should have the same effect unless
something in your code changes a cell used in a formula AFTER app.calc has
executed.

Mike