How to Disable StatusBar

[Bruce McCormick]

I have a macro that loads, updates, and save several document templates. I
am using a userform to keep the user apprised of the progress. I would like
to disable the statusbar that displays a progress bar when the file is
saved. ScreenUpdating = False doesn't do it. Is there a way to do this?

 

[Bruce McCormick]

By the way, Application.DisplayStatusBar = False does not work either. It
turns off the StatusBar but it refuses to supress the "Word is saving
[document name]" message.

 

[Jonathan West]

By the way, Application.DisplayStatusBar = False does not work either. It
turns off the StatusBar but it refuses to supress the "Word is saving
[document name]" message.

I'm not aware of any means of suppressing messages in the statusbar.

 

[ward]

Hello Bruce,

Maybe you can turn the statusbar off, and back on when you
are finished?

Dim SBstatus As Boolean
SBstatus = Application.DisplayStatusBar

Application.DisplayStatusBar = False
' code here....
Application.DisplayStatusBar = SBstatus

Ward

 

[Bruce McCormick]

Unfortunately, that doesn't work.