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?
|