Workbook Calculations

[austin350s10]

Is there a way using VBA Workbook_Open() to set workbook calculations to automatic if the user does not have automatic calculations turned on?

 

[JackDanIce]

Yes.

Put this in your code at the start

Application.Calculation = xlcalculationmanual

If you want VBA to turn it back on:

Application.Calculation = xlCalculationAutomaic

 

[austin350s10]

Thanks!