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