How to determine which button was clicked on the modified right-click menu
 

I have modified the right-click menu to contain new control items. I wish to
know which button on the newly modified menu was clicked by the user so that
I can appoint differnet macros for different button clicks.

May anyone please give me a clue? Thanks a lot!

How to determine which button was clicked on the modified right-click menu
 

Patrick,

You can use the ActionControl property to get a reference to the control
that was clicked. E.g.,

Msgbox Application.CommandBars.ActionControl.Caption


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Patrick Choi" wrote in message
...
I have modified the right-click menu to contain new control items. I wish
to
know which button on the newly modified menu was clicked by the user so
that
I can appoint differnet macros for different button clicks.

May anyone please give me a clue? Thanks a lot!