Sub WorkbookCalculationManual()
With Application
'Workbook calculation settings
.Calculation = xlCalculationManual 'Change calculation mode to manual
'.CalculateBeforeSave = True 'Recalculate workbook before saving, if saving a workbook takes a long time, set to False.
'.Calculation = xlCalculationAutomatic 'Change calculation mode to automatic
'.Calculation = xlCalculationSemiautomatic 'Automatic except for data tables
'Iterative calculation settings
'.Iteration = True 'Enable iterative calculation
'.MaxChange = 0.01 'Maximum Iterations
'.MaxIterations = 100 'Maximum Change
End With
End Sub
Home » Excel Macros » VBA » Excel VBA: Change Calculation Mode To Manual
Excel VBA: Change Calculation Mode To Manual
ExcelHowTo
1 minute to read
9505
0