Can Circular Reference Warnings be supressed on Workbook Open?

[Mike Blackman]

Hi All,

Just a quick one, hopefully.

I'd have thought the answer would be no, but is there a way of supressing the Circular Reference Warning on Workbook Open?

 

[RoryA]

Why not have the ranges set to something that doesn't cause a circular ref and then reset them in the Workbook_Open event. That way you can control the error.