ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Staus Bar (https://www.excelbanter.com/excel-programming/412770-staus-bar.html)

steven

Staus Bar
 
I was trying to put messages on the Status Bar doing something like.

oldStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Account 101000-1000 Category - Cash"

The problem is how do I switch it back to the regular Status Bar. I tried
to do it but I noticed when I saved the file it was not giving me the Saving
..... response in the status bar.

Thank you,

Steven

Tim Zych

Staus Bar
 
Application.StatusBar = False


--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Steven" wrote in message
...
I was trying to put messages on the Status Bar doing something like.

oldStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Account 101000-1000 Category - Cash"

The problem is how do I switch it back to the regular Status Bar. I tried
to do it but I noticed when I saved the file it was not giving me the
Saving
.... response in the status bar.

Thank you,

Steven




steven

Staus Bar
 
Thank you,

I guess that shows I totally did not understand the concept.

"Tim Zych" wrote:

Application.StatusBar = False


--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Steven" wrote in message
...
I was trying to put messages on the Status Bar doing something like.

oldStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Account 101000-1000 Category - Cash"

The problem is how do I switch it back to the regular Status Bar. I tried
to do it but I noticed when I saved the file it was not giving me the
Saving
.... response in the status bar.

Thank you,

Steven






All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com