Hi, is it possible to add an item to the right mouse-click menu?
Hi, is it possible to add an item to the right mouse-click menu?
Hello Silkworm,
Yes it is. Which of the right click menus did you have in mind?
Sincerely,
Leith Ross
Thanks for replying. I should've been more clear. What I have in mind
is to write some VBA code, and when a user right click on a cell, have
the right-click menu display the option to run the script.
Hello Silkworm,
The following macros Add or Remove your custom control from the context menu (right click) for Worksheet cells. Once you add your control, it will remain on the menu until you run the remove macro. You run this when you close your program. Otherwise the macro will not be available to other Workbooks eventhough the control still appears on the menu. Change the Caption property to what your control does, and the OnAction property to the name of the macro to run.
_____________________________
_____________________________Please Login or Register to view this content.
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks