How can I stop an Excel macro from displaying the intermediate images on the
screen until after it has finished. I guess I'm looking for the VBA
equivalence to "echo off" as in DOS. Your help will be much appreciated.

Brian

Maybe something like:

Application.ScreenUpdating = False
<Yourcode
Application.ScreenUpdating = True

"Brian" wrote in message
...
How can I stop an Excel macro from displaying the intermediate images on
the
screen until after it has finished. I guess I'm looking for the VBA
equivalence to "echo off" as in DOS. Your help will be much appreciated.

Brian

To suppress both messages and screen updates you could use the following:

With Application
.DisplayAlerts = False
.ScreenUpdating = False
.StatusBar = "Processing your request, please wait..."
End With

your code goes here

And then reset the environment with the following:

With Application
.DisplayAlerts = True
.ScreenUpdating = True
.StatusBar = False
End With

--
Kevin Backmann


"Brian" wrote:

How can I stop an Excel macro from displaying the intermediate images on the
screen until after it has finished. I guess I'm looking for the VBA
equivalence to "echo off" as in DOS. Your help will be much appreciated.

Brian

Thank you for your help.

Brian

"Brian" wrote in message
...
How can I stop an Excel macro from displaying the intermediate images on
the
screen until after it has finished. I guess I'm looking for the VBA
equivalence to "echo off" as in DOS. Your help will be much appreciated.

Brian