a macro that runs automatically when a workbook is opened

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

Gary''s Student

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

david netser

many thanks, it worked perfectly. david

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top