Hi Arnard,
I have researched further for you on this issue. However, based on my research, the xla is deisgned to work after the installation. If you want to
double-click it or load it from the commandline, this goes into editting mode. Then in the editting mode, as you have seen, the Excel event can be
handled by the xla which is used for your modification on this add-in. You can see this as design time, not runtime. When the add-in is installed,
the xla works in runtime. My sample will illustrator how to load/unload add-in for you.
However, I suddenly realized your requirement may be one very wonderful product enhancement. So I'd suggest you can forward this to Microsoft
Wish program. Let us know how we can improve our products.
1. World Wide Web
a)In Internet Explorer 6, click Send Feedback on the Help menu and then click the link in the Product Suggestion section of the page that
appears.
b)In Windows XP, click Help and Support on the Start menu. Click Send your feedback to Microsoft, and then fill out the Product Suggestion page
that appears.
c)Visit the following Microsoft Web site:
http://www.microsoft.com/ms.htm
d)Click Microsoft.com Guide in the upper-right corner of the page and then click Contact Us . Click the link in the Product Suggestion section of
the page that appears.
e)Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.
2. E-mail - To send comments or suggestions via e-mail, use the following Microsoft Wish Program e-mail address,
.
3. FAX - To send comments or suggestions via FAX, use the following Microsoft FAX number, (425) 936-7329.
NOTE : Address the FAX to the attention of the Microsoft Wish Program.
4. US Mail - To send comments or suggestions via US Mail, use the following Microsoft mailing address:
Microsoft Corporation
Attn. Microsoft Wish Program
One Microsoft Way
Redmond, WA 98052-6399
Please feel free to let me know if you have any further questions.
Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
----------------
MORE INFORMATION
Each product suggestion is read by a member of our product feedback team, classified for easy access, and routed to the product or service team
to drive Microsoft product and/or service improvements. Because we receive an abundance of suggestions (over 69,000 suggestions a year!) we
can't guarantee that each request makes it into a final product or service. But we can tell you that each suggestion has been received and is
being reviewed by the team that is most capable of addressing it.
All product or service suggestions received become the sole property of Microsoft. Should a suggestion be implemented, Microsoft is under no
obligation to provide compensation.