Turn Off Circular Reference Message

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

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 Auto_Open()
On Error Resume Next
Application.DisplayAlerts = False
End sub

Regards,
Ryan--
 
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--
 
Back
Top