in the workbook before close event, remove the circular references or make
the formulas text strings. In the workbook.Open event, change iterations
and restore the formulas.

--
Regards,
Tom Ogilvy

"Craig" <cschelskeatdmedotcom wrote in message
...
I have a worksheet that has a circular reference but I have my Interations
set to 1000 so the circular turns off. I have a macro setup so when other
users open the worksheet, it turns in interations on and sets it to max.
interations to 1000. The problem is, when I open the workbook, the
worksheet calculates before my macro for seting the interation level, and
the circular reference warning appears. IOnce I it cancel, then the
interation macro runs and there circular is taken care of. Is there
anyway
to make my interation maco occur before the worksheet calculates and
causes
a circular reference warning. I have end users who panic when any type of
message appears, and want to eliminate any stress in their lives.

Thanks for any help!