a macro that runs automatically when a workbook is opened

  • Thread starter Thread starter david netser
  • Start date Start date
D

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?
 
Make sure you have installed the macro in the workbook code area and not a
standard module.
 
Back
Top