I’ve just posted the code I use to speed up VBA execution on the codematic site here.
its just a pair of routines to turn events, screenupdating and calc off. The only thing it does which is vaguely interesting is try to maintain the calc settings as they were prior to code execution.
Public Sub speed()
On Error Resume Next
If Not mbInSpeed Then
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
mlCalcStatus = Application.Calculation
Application.Calculation = xlCalculationManual
mbInSpeed = True
‘we are already in speed – don’t do the settings again
I was ignoring remote requests too but that is bit of a pain if Excel crashes.
Is there anything you would add or remove?