VB code to set iteration

[Guest]

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.

 

[Guest]

try putting this in...

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

 

[Guest]

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.

 

[Roger Govier]

Hi Ken

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