Calculation / Iteration

How can I set(check) in Tools/Options/Calculation the Iteration option, and the values of "Max. Iterations" and "Max. Change" in Workbook Open/Activate ???

S.Krol

Add this code to your ThisWorkbook module (Right click the Excel Icon in the
uppper left corner of the Excel window and choose View Code)

Private Sub Workbook_Open()
MsgBox Application.Iteration & vbTab & _
Application.MaxIterations & vbTab & _
Application.MaxChange
End Sub
--
HTH...

Jim Thomlinson


"skrol" wrote:

>
> How can I set(check) in Tools/Options/Calculation the Iteration option,
> and the values of "Max. Iterations" and "Max. Change" in Workbook
> Open/Activate ???
>
> S.Krol
>
>
> --
> skrol
> ------------------------------------------------------------------------
> skrol's Profile: http://www.excelforum.com/member.php...o&userid=27126
> View this thread: http://www.excelforum.com/showthread...hreadid=470868
>
>

Thanks Jim,

Wat I realy wanted was this.
Setting the iteration values.
This works.

Private Sub Workbook_Open()
Application.Iteration = True
Application.MaxIterations = xx
Application.MaxChange = yy
End Sub

S.Krol ....