a macro that runs automatically when a workbook is opened

[david netser]

i am trying to write a macro which will turn on Iteration whenever a workbook
is opened, i have written the following:
Private Sub Workbook_Open()

With Application
.Iteration = True
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False

End Sub

and it doesnt work, would you know why?

 

[Gary''s Student]

Make sure you have installed the macro in the workbook code area and not a
standard module.

 

[david netser]

many thanks, it worked perfectly. david

Make sure you have installed the macro in the workbook code area and not a
standard module.