xla creating new menu items

[dspencer]

I've created an XLA, which adds various functionality to Excel to lin
with another application.

This works perfectly both as an XLS and an XLA file.

I have also written some code to add menu items, which needs to run a
a Workbook_Activate macro.

Again, this works perfectly as an XLS file, but the minute it i
converted into an XLA, it fails to run.

I'm using Excel 2003, and fear that this is something to do wit
Trusted Sources etc, but all security is set to low, and "Trust al
installed addins" is ticked, so I thought it should work.

The only thing I can think of is that Workbook_Activate has to b
replaced by something like Addin_Activate, but that doesn't seem t
work.

Any ideas

 

[Tom Ogilvy]

An XLA is never activated. If you want code to run when this workbook is
loaded, use the Workbook_Open event.

 

[dspencer]

Thanks a lot Tom - It worked perfectly!


Dan