a macro that runs automatically when a workbook is opened
 

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?

a macro that runs automatically when a workbook is opened
 

Make sure you have installed the macro in the workbook code area and not a
standard module.
--
Gary''s Student - gsnu200860


"david netser" wrote:

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?

a macro that runs automatically when a workbook is opened
 

many thanks, it worked perfectly. david

"Gary''s Student" wrote:

Make sure you have installed the macro in the workbook code area and not a
standard module.
--
Gary''s Student - gsnu200860


"david netser" wrote:

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?