EnableCalculation Property
Applies To
Worksheet object.
Description
True if Microsoft Excel automatically recalculates the worksheet when necessary. False if the user must request a recalculation (Microsoft Excel never recalculates the sheet automatically). Read/write Boolean.
Remarks
When you change this property from False to True, Microsoft Excel recalculates the worksheet.
Example
This example sets Microsoft Excel to not recalculate worksheet one automatically.
Worksheets(1).EnableCalculation = False