Set Status bar back to "Ready"
 

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

Set Status bar back to "Ready"
 

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

"Steven" wrote:

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