How to trigger code in Excel add-in after double-click or right-cl

[Guest]

Hello,

I have written an Excel add-in (.XLA) and I would like to trigger some code
located in this add-in when the user double-click or right-click a cell in
the active worksheet/workbook.

I could place the code in the active workbook using the BeforeDoubleClick or
BeforeRightClick event but I really want to have the code in the .XLA for
maintenance reasons.

Any help would be appreciated.

Many thanks.
François.

 

[ivan.raiminius]

Hi Francois,

use application events.

Regards,

Ivan

 

[Guest]

Got it.
Many thanks for you help.
François.

"(e-mail address removed)" a écrit :