View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to add an entry in the Excel Right-Click Menu

If you are familiar with adding custom controls, then it is no different -
just working with the Cell commandbar.

This article talks about an error, but also provides sample code on how to
do it:

http://support.microsoft.com/default...b;en-us;171025
XL97: Macro Error Creating Custom Shortcut Menu Item

http://support.microsoft.com/default...b;en-us;213696
XL2000: Macro Error Creating Custom Shortcut Menu Item

--
Regards,
Tom Ogilvy


"Vobiscum" wrote in message
...

Hello,

I'd like to add contextual entries in the right-click excel menu, ie:

When selecting 2 cells and right clicking, I'd like the two first
entries in the menu to be VBA functions that I designed

Could you help ?

Thanks,

vobiscum


--
Vobiscum
------------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=2459
View this thread: http://www.msusenet.com/t-1870552916