Set Calculation Mode to Automatic without calculating
Hi Jim (and the others too)
I figured I would have to *manually* fake the autocalculation whenever
required.
I was just hoping someone would come up with an idea on how to set
calculation mode back to automatic without firing a calculation.
At some point I thought I found a way with the CalculationState
property but unfortunately it's a read-only property and I can't set it
to xlDone myself like I trick the Saved property of the workbook before
close.
Thanks anyway.
Just in case there's still a solution around, anybody else?
Jerome
|