Hola Folks,

environment:
- Excel 2003, VBA, Add-In (XLA)

I have added several menuitems to the Excel menu during the
registration of an add-in. Is there a way to handle onclick events for
the menu items I have added?

Right now, each one of the menu items has a different onaction
subroutine that stores an ID specifying which button was clicked in a
global variable.

In the end, I'd like to hook all of the onclick events for the menu
items that I have added through a single function. Even if they all
have the same function set in their onAction properties, it doesn't
look like I have a method of determining which of the menu items was
clicked.
I'd like to be able to get a handle to the control / menu item and
evaluate whatever is stored in the tag property. The only way I know of
to do this is kludgy and most importantly, doesn't seem to work as
expected across sessions.

I hope this is clear enough to make sense because I'm very tired and
probably not communicating effectively.



-V-