Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want open file for click double mouse | New Users to Excel | |||
adding apostrophe macro? | Excel Discussion (Misc queries) | |||
adding an option to the right click menu | Excel Discussion (Misc queries) | |||
adding an option in the right click menu | Excel Discussion (Misc queries) | |||
When I drag the mouse arrow over menu buttons, no description app. | Excel Discussion (Misc queries) |