Excel VBA: Change Calculation Mode To Manual

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

Leave a Reply

Your email address will not be published. Required fields are marked *