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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA equivalence tp to DOS "echo off" 3
ECHO OFF applying to MULTIPLE Macros or MODULES! 1
Echo off 6
Echo does not return variables 0
Preventing Screen Repaint - what confilicts with Echo? 1
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Cell Echoing Help in VBA 2
Missing characters when command echoed to screen 2

Back
Top