Manual calculation on Open

[Dannyh1]

Hi,

I have the following code

Private Sub Workbook_Open()
 
Application.Calculation = xlCalculationManual
 
End Sub

The problem is I don't want anything to calculate when the file is opened. This code calculates the spreadsheet & then switches the calc to manual.

Is there a way around this?

Thanks

 

[RoryA]

You would need to set the sheet's calculation property when you save and close the workbook. It's too late when you open it.