Worksheet.EnableCalculation Property
True if Microsoft Excel automatically recalculates the worksheet when necessary. False if Excel doesn't recalculate the sheet. Read/write Boolean.
Syntax
expression.EnableCalculation
expression A variable that represents a Worksheet object.
Remarks
When the value of this property is False, you cannot request a recalculation. When you change the value from False to True, Excel recalculates the worksheet.
Example
This example sets Microsoft Excel to not recalculate worksheet one automatically.
| Visual Basic for Applications |
|---|
|