Adding to Right-Click Context Menu

I'm not sure if this is complicated or if I am making it complicated in my mind.

Objective: I would like to add a new item on the right-click context menu in excel. When this new item is clicked I would like it to open up a designated user form.


So far I have figured out how to open a user form by overriding the right click menu completely and opening the user form. However, I want the user form to open only when selected on the right click menu.


Is this complicated? If anyone has idea, guidance, or the solution that would be helpful.

This is how you add it

Please Login or Register  to view this content.

and to remove it

Please Login or Register  to view this content.

Thank you!! It works great!

I'll post my code as well to document it. Thank you again!

Since I wanted the Right-click item to appear in the entirety of the workbook I used Bob Phillips code as follows

Please Login or Register  to view this content.

To remove the item after excel closes, so the items don't continually build up, I used the "remove it" segment of code as follows

Please Login or Register  to view this content.

Also, the idea was to open a user form from the new item on the right click menu. Bob Phillips' "add it" segment of code calls the macro .OnAction = "Another"

I created a module and added the following code

Please Login or Register  to view this content.