Turn Off Circular Reference Message

[ryguy7272]

I am using a Circular Reference in one sheet in a workbook and keep getting
the Circular Reference message. Is there a way to turn this message off? I
am using the code below, but it doesn’t resolve the issue:

Private Sub Autpen()
On Error Resume Next
Application.DisplayAlerts = False
End sub

Regards,
Ryan--

 

[JE McGimpsey]

Tools/Options/Calculation, check Iteration.

 

[ryguy7272]

Yes, that does the trick. For some reason, the default for Iteration seems
to be 'unchecked'. I seem to recall that this is ALWAYS unchecked when Excel
starts. Is that true? If so, then I always have to check the box each time
I start Excel to get around the problem... Can you confirm JE?

Regards,
Ryan--