xla creating new menu items
 

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

--
dspence
-----------------------------------------------------------------------
dspencer's Profile: http://www.excelforum.com/member.php...fo&userid=3096
View this thread: http://www.excelforum.com/showthread.php?threadid=50633

xla creating new menu items
 

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" wrote in
message ...

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

xla creating new menu items
 

Thanks a lot Tom - It worked perfectly!


Dan


--
dspencer
------------------------------------------------------------------------
dspencer's Profile: http://www.excelforum.com/member.php...o&userid=30967
View this thread: http://www.excelforum.com/showthread...hreadid=506334