Macro Optimization - danielep71/VBA-PERFORMANCE GitHub Wiki

Home

The basic idea behind this class is to turn off every Excel functionality and setting not required (but the essentials), causing unnecessary waste of time while the code is running.

The following functionalities can usually be turned off while VBA executes:

Screen Updating
Automatic Calculation
Events
Status Bar
Page Breaks

Important: remember to restore this functionality to its original state after your code executes.

Home