View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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