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 letFrom what I understand, my syntax should be something likeOnAction = "MyCOMAddin.MySub"But it does not seem to work..OnAction = "!<MYCOMADDIN.MYSUB>"
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