adding macro to right mouse click menu
 

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

adding macro to right mouse click menu
 

This can be done only with code.

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


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




"JimB" wrote in message
...
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