I need to ensure that iteration is "on" when a particular workbook opens.
I've read the thread between Sharkfoot and Sandy Mann, but all I'm looking
for is some code that will activate when the spreadsheet opens, to set
iteration "on" before it checks for circular references.

try putting this in...

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

"Ken G." wrote:

I need to ensure that iteration is "on" when a particular workbook opens.
I've read the thread between Sharkfoot and Sandy Mann, but all I'm looking
for is some code that will activate when the spreadsheet opens, to set
iteration "on" before it checks for circular references.

Thanks John, but this didn't work. Where should the macro go? I tried it in
the worksheet, and in a module but it didn't set the iteration.

"John" wrote:

try putting this in...

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

"Ken G." wrote:

I need to ensure that iteration is "on" when a particular workbook opens.
I've read the thread between Sharkfoot and Sandy Mann, but all I'm looking
for is some code that will activate when the spreadsheet opens, to set
iteration "on" before it checks for circular references.

Hi Ken

You need to put the code in the This Workbook module, not a sheet
module.

--
Regards

Roger Govier


"Ken G." wrote in message
...
Thanks John, but this didn't work. Where should the macro go? I tried
it in
the worksheet, and in a module but it didn't set the iteration.

"John" wrote:

try putting this in...

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

"Ken G." wrote:

I need to ensure that iteration is "on" when a particular workbook
opens.
I've read the thread between Sharkfoot and Sandy Mann, but all I'm
looking
for is some code that will activate when the spreadsheet opens, to
set
iteration "on" before it checks for circular references.