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

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

I did not quite understand your Question. The Makro was added by
starting the VB-Editor while the workbook was open and adding a module
and a private sub procedure.
In the Project-Window of the editor I can see two folders: the first
folder with the Objects "This Workbook" and three tables and the second
folder with "Module1" which has my Makro in it as a "Private sub"

The security settings are on "low"

Dave Peterson wrote:
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

Sub auto_open()

Application.Iteration = True

End Sub





" wrote:

I did not quite understand your Question. The Makro was added by
starting the VB-Editor while the workbook was open and adding a module
and a private sub procedure.
In the Project-Window of the editor I can see two folders: the first
folder with the Objects "This Workbook" and three tables and the second
folder with "Module1" which has my Makro in it as a "Private sub"

The security settings are on "low"

Dave Peterson wrote:
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

Yippeee!! It works

Thanks a lot for your help.

Cheers,
Anand

Rich wrote:
Sub auto_open()

Application.Iteration = True

End Sub





" wrote:

I did not quite understand your Question. The Makro was added by
starting the VB-Editor while the workbook was open and adding a module
and a private sub procedure.
In the Project-Window of the editor I can see two folders: the first
folder with the Objects "This Workbook" and three tables and the second
folder with "Module1" which has my Makro in it as a "Private sub"

The security settings are on "low"

Dave Peterson wrote:
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

anytime

" wrote:

Yippeee!! It works

Thanks a lot for your help.

Cheers,
Anand

Rich wrote:
Sub auto_open()

Application.Iteration = True

End Sub





" wrote:

I did not quite understand your Question. The Makro was added by
starting the VB-Editor while the workbook was open and adding a module
and a private sub procedure.
In the Project-Window of the editor I can see two folders: the first
folder with the Objects "This Workbook" and three tables and the second
folder with "Module1" which has my Makro in it as a "Private sub"

The security settings are on "low"

Dave Peterson wrote:
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