logo ASAP Utilities

Excel tip: Improve the speed of your macro's

Date: 27 september 2001

Turn 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

Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
© 1999-2021 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook