Save "limit iterations"

[Maartenovich]

Hi all,

I have an Excel sheet that I send to customers that has one intended circular reference. This is no issue when I check "limit iterations" box and set it to 1. However this setting is not saved to the workbook and each time a customer opens the workbook he/she gets the circular reference error, which tends to freak some people out.

Sooo, does anyone know a solution to this issue?

Much appreciated!

 

[oldbrewer]

Do customers need working formulas - if not edit, select all, copy, paste special, values

 

[mole999]

Sub Macro1()
'
' Macro1 Macro
'

'
    With Application
        .Iteration = True
        .MaxIterations = 1
    End With
End Sub

 

[Maartenovich]

Perfect! Thanks a lot!

 

[mole999]

just remember to reset it for you user when your program closes normally