Handling Excel Evens in addins

[Guest]

I have a dilemma

I have 2 excel add-ins installed, both of with need to handle the Workbook
close events.
However I need one add-in to handle the event before the other.
Is it possible to establish the order in which add-ins handle the event?

Regards

 

[bobbo]

Yo could combine the two procedures into a single procedure and this
would allow you to control the order of events.

 

[Guest]

Hi, thanks for the prompt response.

The 2 addins are from different vendors, so I cannot combine the functionas.

Thanks

 

[Bob Phillips]

Put both bits of Close code in the one addin, in the correct order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

Then you are stuck, unless you can get them to tailor the product(s).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Peter Huang [MSFT]]

Hi Tim,

The Excel Event is an callback mechanism, it did not defined the order for
us to change, because event is not a message handle.

Currently I think you may try to contact the two vendor to see if they have
any changed versions for your scenario.

If you have other concern, please let me know.

Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.