"Ready"
Here is how to set the status bar...
Application.StatusBar = "Test"
And here is how to reset it...
Application.StatusBar = ""
It is usually a good idea to have an error handler when you are using this
code to reset the value if the code crashes...
HTH
"Arturo" wrote:
How do I alter the bottom left corner of Excel which usually displays Ready
or Calculating Cells, to say what I choose while code is running, and then
reset it when done?
Appreciatively
Arturo
|