Excel Guides

Turning Off Screen Updating in Excel

There are a few reasons why you might want to turn off screen updating in Excel. Maybe you have a macro that runs a lot of code and you don't want the user to see all the flickering as the macro does its thing. Or maybe you are running some code that takes a while to finish and you don't want the user to think that Excel has frozen. In either case, turning off screen updating can make your macro run a lot faster.

There are two main ways to turn off screen updating in Excel. The first is to use the Application.ScreenUpdating property:

Application.ScreenUpdating = False

You can put this line of code at the beginning of your macro to turn off screen updating. Then, when your macro is finished, you can put this line of code at the end:

Application.ScreenUpdating = True

This will turn screen updating back on so that the user can see what's going on again.

The other way to turn off screen updating is to use the DisplayAlerts property:

Application.DisplayAlerts = False

This will not only turn off screen updating, but it will also prevent any alerts or messages from popping up. So if your macro is going to do something that might cause an alert (like deleting a sheet), then using DisplayAlerts is a good idea.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.