View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] r.c.j.tongeren@arcadis.nl is offline
external usenet poster
 
Posts: 2
Default 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