Return to Snippet

Revision: 57785
at June 9, 2012 08:34 by joseamirandavelez


Initial Code
Function turnEverythingOff()
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Application.EnableEvents = False
End Function

Function turnEverythingOn()
    Application.ScreenUpdating = True
    Application.Calculation = xlCalculationAutomatic
    Application.EnableEvents = True
End Function

Initial URL

                                

Initial Description
Turn off screen updating, formula calculation and events in order to prevent Excel from doing all of them and speed up macro execution.

Initial Title
Speed Up Excel Macro Execution

Initial Tags

                                

Initial Language
Visual Basic