Results 1 to 8 of 8

Thread: Auto Calculation Toolbar Button

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    VBAX Regular
    Joined
    Jun 2004
    Location
    Cordova, Alaska
    Posts
    10
    Location

    Toggle Auto/ Manual Calculation

    Hi,
    Don't know if you need help creating the toolbar button or not, but for the code you can use:
    Sub ToggleAutoManualCalc()
    With Application
        If Not .Calculation = xlManual Then .Calculation = xlManual 
        Else: .Calculation = xlAutomatic
        End With
    End Sub
    This any help?

    Dan
    Last edited by Aussiebear; 04-29-2023 at 10:34 PM. Reason: Adjusted the code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •