Replace Right-Click menu

**bstubbs** · 07-29-2009, 12:43 PM

Howdy:

I want to be able to give my application menu when the user right-clicks on a specific series of cells. I've already got the code that will limit the right-click options to the cells that I want. How do I then form and execute the menu that I want the user to see - "Archive Data", "Edit Data", "Add Data", for instance, rather than the normal right-click menu?

Any ideas?

TIA.

Bob

**Bob Phillips** · 07-29-2009, 03:38 PM

Please Login or Register  to view this content.

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.