The workbook open event fires after the error has been displayed to the
user. Is that what you meant? Open the workbook, respond to the error
message, then the workbook open event will set the calculation mode?

--
Regards,
Tom Ogilvy

"Ken Wright" wrote in message
...
How about the following in the ThisWorkbook module of the workbook that
needs
the iterations:-

Private Sub Workbook_Open()
With Application
.Iteration = True
.MaxChange = 0.001
End With
End Sub

and perhaps the opposite to shut it off when it is closed

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Tom Ogilvy" wrote in message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004