Call an addin Macro from Workbook_Open event
 

Ik have an Excel 2003 Addin with several Macro's. One of the macro's
should start if I open an existing workbook. The only way I know is to
create a template with an event which call the macro from the AddIn.
This has two disadvantages
- It's only working in new workbooks
- I the enduser has set the security to a high lever it won't work

Example
I want to call the macro Activate_form from a XLA addIn when I open a
new or existing workbook without macro's in the new or existing
workbook. I only want to have macro's in de Addin.

Does anybody knows a way to reach this.

Thanks
Ruud

Call an addin Macro from Workbook_Open event
 

Use application level events in the addin

http://www.cpearson.com/excel/appevents.htm

--
Regards,
Tom Ogilvy


" wrote:

Ik have an Excel 2003 Addin with several Macro's. One of the macro's
should start if I open an existing workbook. The only way I know is to
create a template with an event which call the macro from the AddIn.
This has two disadvantages
- It's only working in new workbooks
- I the enduser has set the security to a high lever it won't work

Example
I want to call the macro Activate_form from a XLA addIn when I open a
new or existing workbook without macro's in the new or existing
workbook. I only want to have macro's in de Addin.

Does anybody knows a way to reach this.

Thanks
Ruud

Call an addin Macro from Workbook_Open event
 

Thanks,

That was the information where I was looking for and its works as
describes on that site