Stopping one sheet from calculating
On Jun 26, 7:32*pm, Xt wrote:
Is there a way to turn the calculation of a particular
sheet off and on using VBA while the VBA is working with
data from another sheet?
No. Automatic v. manual calculation mode applies to the entire
workbook, not individual sheets. In fact, I believe it applies to all
workbooks open in the same Excel instance.
However, after setting Application.Calculation=xlCalculationManual,
you can use Sheets("sheet1").Calculate to cause one worksheet to
recalculate.
|