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 comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>