Enable / Disable Iterative Calculations

[wilsjohn]

Hi,

Can anyone help me to build a button which enables/disables iterative calculations?

I'm not really sure how to do it and I have googled it all to no avail.

 

[DRSteele]

It's in Files | Options | Formulas | Enable iterative calculations.

 

[Eric W]

Where do you want the button? On a sheet, on the ribbon? The basic code for this is quite simple:

Private Sub CommandButton1_Click()
    Application.Iteration = Not Application.Iteration
End Sub