C
Claude
Hi all
I have a file which I only want to calculate manually. I
tried the following:
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
When I open this file while another file is open
(calculation set to automatic), excel however first
calculates the file, and only then sets the calculation
mode to manual! How can I work around this?
I have a file which I only want to calculate manually. I
tried the following:
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
When I open this file while another file is open
(calculation set to automatic), excel however first
calculates the file, and only then sets the calculation
mode to manual! How can I work around this?