Calculation Property
XlCalculation
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
Applies to | Spreadsheet Object
See Also | Calculate Method | CalculateFull Method