VBA – Turn off Screen Updating

Associated Files Download Links


As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.

Disable Screen Updating

1. At the beginning of your code put this line:

Enable Screen Updating

2. At the end of your code put this line:

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!

VBA Turn Off On ScreenUpdating


<<Return to VBA Examples

Did you find this VBA tutorial useful? Then share it with your friends and colleagues:

You may also like some of this related content...

Display Fullscreen You can launch Excel to display fullscreen using VBA by using this line
Hide Excel There may occasionally arise a need to hide all of excel, a good
ActiveWindow.Zoom You can use VBA to change the Zoom of a worksheet. Here's code to
Fit Selection In a Worksheet you can use View->Zoom->Fit Selection to automatically adjust the Zoom
Page Break Preview Mode To place Sheet1 in Page Break Preview View from code: Sheet1.Activate
Ads