Set Status bar back to "Ready"

  • Thread starter Thread starter Steven
  • Start date Start date
S

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
 
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
 
Back
Top