constant specifying the calculation mode. Read/write.
| XlCalculation can be one of these XlCalculation constants. |
| xlCalculationAutomatic Formulas are calculated automatically when precedent cells are changed. |
| xlCalculationManual Formulas are not recalculated until the user initiates a recalculation. |
expression.Calculation
expression Required. An expression that returns a Spreadsheet object.
Example
This example places Spreadsheet1 into manual calculation mode.
Sub ManualCalculationMode()
Dim ssConstants
Set ssConstants = Spreadsheet1.Constants
' Set Spreadsheet1 to manual calculation mode.
Spreadsheet1.Calculation = ssConstants.xlCalculationManual
End Sub