+ Reply to Thread
Results 1 to 4 of 4

Adding a item to the right click menu?

  1. #1
    silkworm
    Guest

    Adding a item to the right click menu?

    Hi, is it possible to add an item to the right mouse-click menu?


  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Silkworm,

    Yes it is. Which of the right click menus did you have in mind?

    Sincerely,
    Leith Ross

  3. #3
    silkworm
    Guest

    Re: Adding a item to the right click menu?

    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.


  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1