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
Sub TurnOff()
On Error Resume Next
With Application
.Calculation = xlCalculationManual
.ScreenUpdating = False
.EnableEvents = False
.CutCopyMode = False
.DisplayAlerts = False
.AutoRecover.Enabled = False
End With
On Error GoTo 0
End Sub