I want to turn of automatic calculation in Excel from my add-in
and have put the following code in the ThisWorkbook module.

Private Sub Workbook_Open()

Application.Calculation = xlCalculationAutomatic
End Sub


When starting Excel and there by loading the add-in I get the following
error:

Method 'Calculation' of object '_Application' failed

I seems to be the problem?

Lars