VBA equivalent to "echo off"
Sub Whatever()
Application.ScreenUpdating = False
Your code here
Application.ScreenUpdating = True
End Sub
Biff
"Brian" wrote in message
...
How can I stop an Excel macro from displaying the intermediate steps on
the screen except until after it has completed. I guess I'm looking for
the VBA equivalence to "echo off" for DOS. Your help will be much
appreciated.
Brian
|