Set Status bar back to "Ready"

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Status Bar shows "Calculate", but calculation is set to Automatic 1
Macro runs fine from VBEditor, but not button 22
Status Bar more complex 1
Saving time on calculate 2
Code for avoiding slashes, ampersands, etc. when naming sheets 6
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
How to control recalculation in VBA? 1
Looping a Macro 4

Top