| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| when excel opens it is in "ready mode" | Excel Discussion (Misc queries) | |||
| Using the "Ready" Message Bar instead of MSBOX | Excel Programming | |||
Hybrid Mode
