Excel 2000 - Events for shapes (i.e. popup shortcut menus)
Posted on 2001-08-10
I am trying to figure out if there is a way to make events for drawing shapes in Excel 2000. Let me try to explain. A worksheet has events such as "selectionchange", "beforerightclick" and "beforedoubleclick". If I write this code into a worksheet module:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
This disallows me from getting a popup shortcut menu when right clicking over a cell. However, if I right click over a drawing shape I DO indeed get the shortcut menu. So obviously drawing shapes are handled differently. But the fact that a drawing shape can respond to the right click by displaying a popup menu tells me that somehow it does have events that control it. But I have no idea of how to access any events that control a shape. Does that make any sense? Ultimately I want to create a custom popup shortcut menu only when right clicking on a shape and not for the cells. Thanks for any help you can give me.