Thread: "Ready"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default "Ready"

Hi,
To set the status bar to your text use.....

Application.StatusBar = "Your Test"

to revert to normal (Excel controlled) use.....

Application.StatusBar = False

to hide it use .....

Application.DisplayStatusBar = False

--
Cheers
Nigel



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