Thread: "Ready"
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default "Ready"

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