Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Ready"
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Ready"
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 |
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 - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | 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 |