Hi Richard,

Application.Statusbar=""

There is a subtle problem with this.

From the intermediate window:

Application.StatusBar = "HELLO"
? Application.StatusBar
HELLO

Application.StatusBar = ""
? Application.StatusBar
False

Application.StatusBar = False
? Application.StatusBar
FALSE

The instruction: Application.Statusbar=""
replaces the statusbar message with an empty string and suppresses the
default message.


---
Regards,
Norman



"Richard Buttrey" wrote in
message ...
On Fri, 19 Aug 2005 10:32:47 +0100, "Karoo News"
wrote:


I have forgotten how to do this and Help does not solve this problem.

All I need to know is how to Reset the statusbar to normal when a wokbook
closes or deactivates. (The open workbook has its own message when
activated)

Many Thanks
Neil

Application.Statusbar=""

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________