Turning on iterations

**Davidns** · 03-25-2012, 12:20 PM

Is there a way to make sure iterations are turned on at all times? I have turned it on, but periodically it seems to revert back to off.

Any suggestions?
Thanks

**Dennis7849** · 03-25-2012, 02:37 PM

iterations of what??

**martindwilson** · 03-25-2012, 02:43 PM

iteration or auto calculation is set by the first work book you open. so if that has iteration off then subsequent ones will too and vica versa
try in the work book you want iterations always on
Private Sub Workbook_Open()
Application.Iteration = True
End Sub