View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default Status Bar Reset

On Fri, 19 Aug 2005 11:51:16 +0100, "Norman Jones"
wrote:

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


Thanks Norman,

You live and learn - as they say.

I'd often thought, (but obviously not very deeply), that there was
perhaps something not quite right about .statusbar="".

Now I know.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________