C
Craig
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!
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!