View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default 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