The options for calculate are set by the first file opened by excel when you
start it. I believe you would need to have two files - one that the user
opens and which has code to set the iteration option, then which opens your
current workbook with that code.

--
Regards,
Tom Ogilvy

"CiaraG" wrote in message
...
Good Afternoon All,

I have a workbook were the circular reference check has
been disabled ie. within the Tools/Options/Calculation
Tab - the Iteration CheckBox is ticked.

However, if another MS Exel file is opened prior to
opening my workbook, then the circular reference check is
activated.

Does anyone have any idea how I can prevent this from
happening??

Thanks

Ciara