My goof... I grabbed this from a project that I am working on where I want to
keep control of the status bar throughout the execution. I reset the status
bar on error or on exit using

application.statusbar = false

I should really be more careful... Thanks Tom

"Tom Ogilvy" wrote:

If you want it to be dead you can use:

And here is how to reset it...
Application.StatusBar = ""

If you want to return control to excel (which is what most people want) you
would use

Application.StatusBar = False

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
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