"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 |
"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 |
"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 |
"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 |
"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 |
All times are GMT +1. The time now is 03:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com