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 Download All added Excel tools Sitemap Contact Us

Empowering Excel Users Worldwide for 25 Years