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

Use application level events in the addin

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

--
Regards,
Tom Ogilvy


"(E-Mail Removed)" 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
>
>

Thanks,

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