Turn on Auto Calculation to Workbooks.Add

[fpskidmark]

Hi Guru,

I'm currently working on a pretty big workbook that is set on Manual Workbook Calculation (Application.Calculation = xlManual).
Q: How can I add a new workbook and set that workbook to Automatic Workbook calculation (Application.Calculation = xlAutomatic) and still keep my big workbook set to Manual Workbook Calculation?

Dim wbn As Workbook
Set wbn = Workbooks.Add

Thank you,
FP

 

[fpskidmark]

Never mind, I've figured it out. Thank you.

 

[Waimea]

How did you solve it?