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
Tom Ogilvy - 28 Aug 2007 19:06 GMT
Use application level events in the addin
http://www.cpearson.com/excel/appevents.htm

Signature
Regards,
Tom Ogilvy
> 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
[quoted text clipped - 12 lines]
> Thanks
> Ruud
r.c.j.tongeren@arcadis.nl - 29 Aug 2007 19:19 GMT
Thanks,
That was the information where I was looking for and its works as
describes on that site