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

  • Thread starter Thread starter Patrick Choi
  • Start date Start date
P

Patrick Choi

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!
 
Patrick,

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

Msgbox Application.CommandBars.ActionControl.Caption
 
Back
Top