This is the procedure l have used for many years to reverse the speed up macro execution time procedure.
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 TurnOn() On Error Resume Next With Application .Calculation = xlCalculationAutomatic 'calcmode .ScreenUpdating = True .EnableEvents = True .AutoRecover.Enabled = True .CutCopyMode = False .DisplayAlerts = True .StatusBar = False End With On Error GoTo 0 ' End Sub