.OnAction = "Macro" Syntax for COM Addin

[Mike_R]

Ok, hey guys, since there's such a lopsided degree of Talent vs. Questioners here at this point, I thought I might throw this one out, and maybe someone here would have a clue.

(I've also put this on Experts-Exchange, but not having much success...)

Here's my Q:

I wish to call a Macro within a COM Addin. Effectively I wish to let

OnAction = "MyCOMAddin.MySub"

From what I understand, my syntax should be something like

.OnAction = "!<MYCOMADDIN.MYSUB>"

But it does not seem to work.

If this were for a CommandBarButton or CommandButton on a Worksheet, then I could use WithEvents and trap the _Click() Event. However, I seek to trap Application.OnKey() which requires a String name of the macro to be called.

Any ideas on what the correct Syntax would be? (Or if this can be done at all.)

Thanks,
Mike