VBA equivalent to "echo off"

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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
 
Sub Whatever()

Application.ScreenUpdating = False

Your code here

Application.ScreenUpdating = True

End Sub

Biff
 
Back
Top