Did you put it behind the ThisWorkbook module?

Did you make sure your macro security settings were either low or Medium (and
you allowed macros)?

wrote:

Hello,

I would like to run a Macro automatically after opening a Workbook, to
set the "Iteration" Option.

I found the following code :
Private Sub Workbook_Open()
Application.Iteration = True
End Sub

However I can't get Excel to start this macro when the workbook gets
opened. I have to start the macro manually.

All help would be graetly appreciated.

Cheers,
Anan dPatel

--

Dave Peterson