Add a custom command to your right mouse-click menu

Almir's picture

When using particular macro often, it is handy to have it on right mouse-click. In this example there is a simple macro "Show Date and Time", and it was added to right mouse-click menu.

Supposing you have a macro called "DateAndTime" in a "Module1", copy code from attached .TXT file to the "Workbook" part in VBE.

With slight modification you can add more commands to the right mouse-click menu. It was explained in the comments.

If you want custom commands available on right mouse-click, regardless of the file you work on, copy the code to your "Personal" macro file.

Add a custom command to your right mouse-click
AttachmentSize
AddMacroRightClick.xlsm18.33 KB
AddCustomCommandRightMouseClick.txt1.91 KB