View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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