Revision: 57785
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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