stop calculation
 

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?