Starting a Makro automatically
 

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

Starting a Makro automatically
 

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

Starting a Makro automatically
 

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

Starting a Makro automatically
 

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

Starting a Makro automatically
 

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

Starting a Makro automatically
 

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