Excel tip: Improve the speed of your macro's
Date: 27 september 2001Turn off screen updating
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 sentence will turn off
the screen updating :
Application.Screenupdating = False
It's not necessary to turn on the screen updating. It will automatically turn on
when the macro is finished. 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 sentence will turn on the screen updating:
Application.Screenupdating = True
Copy-paste friendly code:
' Turn off screenupdating:
Application.Screenupdating = False
' Turn on screenupdating:
' (happens automaticly after a module is finished):
Application.Screenupdating = True
« back
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years