Right-Click to Call a Macro
Here is some code that will allow a user to select your macro from the default menu that appears after they right click a cell.
1. Put the following code in the ThisWorkbook code window
Private Sub Workbook_Open() Dim MyMenu As Object Set MyMenu = Application.ShortcutMenus(xlWorksheetCell) _ .MenuItems.AddMenu("This is my Custom Menu", 1) With MyMenu.MenuItems .Add "MyMacro1", "MyMacro1", , 1, , "" .Add "MyMacro2", "MyMacro2", , 2, , "" End With Set MyMenu = Nothing End Sub
2. Put the following code in a module
Public Sub mymacro1() MsgBox "Macro1 from a right click menu" End Sub Public Sub mymacro2() MsgBox "Macro2 from a right click menu" End Sub
3. Close your workbook and re-open!
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!