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