C
Colin Hayes
HI All
I use this code to turn Automatic Calculation to Manual when I open my
workbook :
Private Sub Workbook_Open()
With Application
.Calculation = xlManual
.MaxChange = 0.001
.CalculateBeforeSave = False
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub
Can someone advise how to extend this so that it switches Automatic
Calculation back on when I close the workbook?
Thanks
I use this code to turn Automatic Calculation to Manual when I open my
workbook :
Private Sub Workbook_Open()
With Application
.Calculation = xlManual
.MaxChange = 0.001
.CalculateBeforeSave = False
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub
Can someone advise how to extend this so that it switches Automatic
Calculation back on when I close the workbook?
Thanks