How to reset the Application.StatusBar

[PCLIVE]

I know this is probably simple, but my brain is having a glitch right now.

How do I reset the Application.StatusBar?

As an example, I have code that states:

Application.StatusBar = "Running"

I know how to make the StatusBar say something else, but how do I reset it
to normal so that it shows the normal things such as "Saving Temporary
File", "Calculating", etc.?

Thanks.
Paul

 

[mpeplow]

Try....

Application.Statusbar = ""

 

[PCLIVE]

I did that. That causes the StatusBar to remain blank and display nothing.

 

[Dave Peterson]

application.statusbar = false

works for me.

I know this is probably simple, but my brain is having a glitch right now.

How do I reset the Application.StatusBar?

As an example, I have code that states:

Application.StatusBar = "Running"

I know how to make the StatusBar say something else, but how do I reset it
to normal so that it shows the normal things such as "Saving Temporary
File", "Calculating", etc.?

Thanks.
Paul

 

[Guest]

You are better off with

Application.Statusbar = False

The line of code you have permanently sets that status bar to blank. The
line of code above returns control of the status bar back to Excel.

 

[PCLIVE]

Many thanks Dave.

That's exactly what I was looking for.

Paul

 

[PCLIVE]

Thanks Jim.

That's it.

You are better off with

Application.Statusbar = False

The line of code you have permanently sets that status bar to blank. The
line of code above returns control of the status bar back to Excel.

 

[mpeplow]

try....
Application.Statusbar = False