adding macro to right mouse click menu

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top