Output ( "The type name of the selected object is " + typeName ) So, I’ve started with printing the type name of the object returned by ExcelApp.Selection (in the code of the add-in, see the method ParseSelection()).Ĭ#: string typeName = Microsoft. How to determine if the object selected in Excel is a shape?īecause Excel.Selection can return almost any type from the Excel type library, you need to check the type of the selected object.
Click the button to start logging events from Excel shapes log records are shown in the pane. The add-in adds a button and an Advanced Task Pane. Occurs when a group of shapes is ungrouped Occurs when a shape(s) is added to the Shapes collection of the current sheet Occurs when a shape(s) is removed from the Shapes collection of the current sheet Occurs before selected shapes are ungrouped Occurs before selected shapes are grouped Occurs when the user selects or deselects a shape(s) So, the events for shapes are as follows: Custom events of Excel shapes Event This isn't a limitation of the approach: this is a restriction of this add-in only (nevertheless, pay attention to an Excel 2002 – 2003 issue described in How to determine if the object selected in Excel is a shape?). Note that individual shapes within a group aren't handled in this add-in.
The sample add-in project available for download at the end of the post creates the custom events listed below. In this blog I demonstrate an approach to solving this problem. The Excel object model doesn’t have any events to control manipulations with shapes.
0 kommentar(er)
