Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
EnableCalculation Property

Worksheet.EnableCalculation Property

Office 2007
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



Community Additions

ADD
Show:
© 2015 Microsoft