hi

All
I am adding a new menus in excel. these menus are
generated dynamically. there is no fix number of menus. I
am generating it using loop.

now i want to assign a click event to every menuitem, in
termes of VBA for every office.CommandBarButton

I have declared one object of this type with withevent
keyword.
the problem is how do I assign these many menusitems to
this withevent object.

It is not possible to create that many withevents object
dynamically for each menuitem.

please send your answers
waiting for reply
regards
Amod