Hi, all.
Because the file is heavy, I turned the calculation option into manual when opening workbook using this code and it works:
But when I put this code to change calculation option back to Automatic when closing workbook,
it gives error: "Compile error: Procedure declaration does not match description of event or procedure having the same name."
What should I do to make it works?
Thank you in advance.
Because the file is heavy, I turned the calculation option into manual when opening workbook using this code and it works:
VBA Code:
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
But when I put this code to change calculation option back to Automatic when closing workbook,
VBA Code:
Private Sub Workbook_BeforeClose()
Application.Calculation = xlCalculationAutomatic
End Sub
What should I do to make it works?
Thank you in advance.