xla creating new menu items

I've created an XLA, which adds various functionality to Excel to link 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 as a Workbook_Activate macro.

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

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

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

Any ideas?

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

--
Regards,
Tom Ogilvy

"dspencer" <[email protected]> wrote in
message news:[email protected]...
>
> I've created an XLA, which adds various functionality to Excel to link
> 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 as
> a Workbook_Activate macro.
>
> Again, this works perfectly as an XLS file, but the minute it is
> converted into an XLA, it fails to run.
>
> I'm using Excel 2003, and fear that this is something to do with
> Trusted Sources etc, but all security is set to low, and "Trust all
> installed addins" is ticked, so I thought it should work.
>
> The only thing I can think of is that Workbook_Activate has to be
> replaced by something like Addin_Activate, but that doesn't seem to
> work.
>
> Any ideas?
>
>
> --
> dspencer
> ------------------------------------------------------------------------
> dspencer's Profile:
http://www.excelforum.com/member.php...o&userid=30967
> View this thread: http://www.excelforum.com/showthread...hreadid=506334
>

Thanks a lot Tom - It worked perfectly!


Dan