Control the screen updating

 1999-07-23    Application    0    128

By turning off the screen updating your macros will run much faster. It will also prevent the disturbing flickering of screen pictures that can frighten inexperienced users. The following line will turn off the screen updating:

Application.Screenupdating = False
You should turn on screen updating again before your macro finishes, not all applications will successfully turn on screen updating again automatically.
Sometimes you want to turn on the screen updating after you have turned it off, e.g. when you want to display a dialog or a message box to the user.
The following line will turn on the screen updating:

Application.Screenupdating = True