Share via


Worksheet.EnableCalculation Property

Excel Developer Reference

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
  Worksheets(1).EnableCalculation = False

See Also