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

Try....

Application.Statusbar = ""


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567080

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

"mpeplow" wrote in
message ...

Try....

Application.Statusbar = ""


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile:
http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567080

application.statusbar = false

works for me.

PCLIVE wrote:

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

--

Dave Peterson

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.
--
HTH...

Jim Thomlinson


"mpeplow" wrote:


Try....

Application.Statusbar = ""


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567080

Many thanks Dave.

That's exactly what I was looking for.

Paul

"Dave Peterson" wrote in message
...
application.statusbar = false

works for me.

PCLIVE wrote:

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

--

Dave Peterson

Thanks Jim.

That's it.


"Jim Thomlinson" wrote in message
...
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.
--
HTH...

Jim Thomlinson


"mpeplow" wrote:


Try....

Application.Statusbar = ""


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile:
http://www.excelforum.com/member.php...o&userid=34812
View this thread:
http://www.excelforum.com/showthread...hreadid=567080

try....
Application.Statusbar = False


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567080