21.3 Iteration Option Enabled
For this scenario, you plan on creating some iterative calculations (circular references). You would like a function that will tell you whether the “Enable iterative calculation” box has been checked so you don’t have to keep going to the Calculation options to see it.
Figure 21.3: Enable iterative calculation checkbox.
This property is found under File ➔ Options ➔ Formulas. Create a UDF named “IterationChecked” that returns True or False, depending on whether “Enable iterative calculation” has been checked. You may need to record a macro to find out the property name so you can return its value.
The following function will work to return an indicator of whether the “Enable iterative calculation” option is checked.