Accessing the shortcut menu for a shape

JCCabrera · Mar 18th, 2002, 02:40 PM

Does anyone come accross how to control a shape's shortcut menu? I have tried to find how to control the shortcut menu (right-click event) when a shape on a worksheet is selected. The shape is independent of a worksheets "before right click" event, thus the shape's shortcut menu cannot be manipulated using the worksheet event.

Al Chara · Mar 18th, 2002, 03:48 PM

What exactly do you want to do here?

You can right-click on it and assign a macro to it. Maybe that will help you.

[ This Message was edited by: Al Chara on 2002-03-18 14:50 ]

JCCabrera · Mar 18th, 2002, 03:54 PM

For those interested in this issue, I finally was able to find the way to access the shape shortcut menu in VBA. Refer to the following item in Excel's command bar collection

Commandbars("Shapes")

Note: Any additions/deletions to items in this menu will affect all shapes that are placed in a workbook. If the menu is to be different for a selected worksheet, use

Commandbars("Shapes").Reset

to ensure that any prior modifications are removed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 02:40 PM	#1
JCCabrera New Member Join Date: Mar 2002 Posts: 2	Does anyone come accross how to control a shape's shortcut menu? I have tried to find how to control the shortcut menu (right-click event) when a shape on a worksheet is selected. The shape is independent of a worksheets "before right click" event, thus the shape's shortcut menu cannot be manipulated using the worksheet event.

Mar 18th, 2002, 03:48 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	What exactly do you want to do here? You can right-click on it and assign a macro to it. Maybe that will help you. [ This Message was edited by: Al Chara on 2002-03-18 14:50 ]

Mar 18th, 2002, 03:54 PM	#3
JCCabrera New Member Join Date: Mar 2002 Posts: 2	For those interested in this issue, I finally was able to find the way to access the shape shortcut menu in VBA. Refer to the following item in Excel's command bar collection Commandbars("Shapes") Note: Any additions/deletions to items in this menu will affect all shapes that are placed in a workbook. If the menu is to be different for a selected worksheet, use Commandbars("Shapes").Reset to ensure that any prior modifications are removed.