Add a custom command to your right mouse-click menu
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.
Attachment | Size |
---|---|
AddMacroRightClick.xlsm | 18.33 KB |
AddCustomCommandRightMouseClick.txt | 1.91 KB |
»
- Almir's blog
- Login or register to post comments
- 6359 reads
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago