adding macro to right mouse click menu

G

Guest

I know how to add macros to toolbars and menus, but I would like to add a
macro to the right mouse click menu in Excel. Can anyone tell me how to
accomplish this? Thanks and regards
 
C

Chip Pearson

This can be done only with code.

With
Application.CommandBars("Cell").Controls.Add(temporary:=True)
.Caption = "Click Me"
.OnAction = "'" & ThisWorkbook.Name & "'!MyMacroName"
End With


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu which appears when you right mouse click in excel sheet 1
Inserting after specific location on right click menu 1
Right Mouse Click 8
Menus / Links associated with right-mouse-click lost! 3
No Menu functions/options when right clicking mouse 1
Shortcut menu won't appear when I click right mouse button. 3
modify mouse menu 1
Right click mouse menu for insert does not work 2

Top