This is the procedure l have used for many years to speed up macro execution time.
This can be edited to suit your requirement by simply changing the boolean values.
How to use; Call Turnoff
Author: michael@excelexperts.co.uk
1 | Sub TurnOff() |
2 |
3 | On Error Resume Next |
4 | With Application |
5 | .Calculation = xlCalculationManual |
6 | .ScreenUpdating = False |
7 | .EnableEvents = False |
8 | .CutCopyMode = False |
9 | .DisplayAlerts = False |
10 | .AutoRecover.Enabled = False |
11 | End With |
12 | On Error GoTo 0 |
13 |
14 | End Sub |