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

--
Tim Marsden

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

Tim Marsden wrote:
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

--
Tim Marsden

Hi, thanks for the prompt response.

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

Thanks
--
Tim Marsden


"bobbo" wrote:

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

Tim Marsden wrote:
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

--
Tim Marsden

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)

"Tim Marsden" wrote in message
...
Hi, thanks for the prompt response.

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

Thanks
--
Tim Marsden


"bobbo" wrote:

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

Tim Marsden wrote:
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

--
Tim Marsden

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)

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

--
Tim Marsden

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.