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 doesnt resolve the issue:

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

Regards,
Ryan--




--
RyGuy

Tools/Options/Calculation, check Iteration.



In article ,
ryguy7272 wrote:

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 doesnt 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--


--
RyGuy


"JE McGimpsey" wrote:

Tools/Options/Calculation, check Iteration.



In article ,
ryguy7272 wrote:

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--