ÿþ<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><script> function getHelp(link) { window.open("http://" + location.hostname + "/Explorer/" + link, "_help", "left=400,resizable=yes,toolbar=yes,width=200,height=200,scrollbars=yes").focus(); } function showReturns(returns) { window.status = returns; } </script><head> <!--[if gte mso 9]><xml> <mso:CustomDocumentProperties> <mso:Order msdt:dt="string">348400.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>Chapter 18</title> <!--mstheme--><link rel="stylesheet" type="text/css" id="onetidThemeCSS" href="../_themes/simple/simp1011-1200.css"><meta name="Microsoft Theme" content="simple 1011, default"> </head><body> <H1>Excel Drawing Objects</H1> <h2>Adjustments (1997) <img src="MSGBOX02.ICO" alt="Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector. Each adjustment value represents one way an adjustment handle can be adjusted. Because some adjustment handles can be adjusted in two ways&amp;nbsp; for instance, some handles can be adjusted both horizontally and vertically&amp;nbsp; a shape can have more adjustment values than it has adjustment handles. A shape can have up to eight adjustments." width="16" height="16" onclick="getHelp('xlobjAdjustments.htm');showMozHelp('Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector. Each adjustment value represents one way an adjustment handle can be adjusted. Because some adjustment handles can be adjusted in two ways&amp;nbsp; for instance, some handles can be adjusted both horizontally and vertically&amp;nbsp; a shape can have more adjustment values than it has adjustment handles. A shape can have up to eight adjustments.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Item [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Single')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Border (1995) <img src="MSGBOX02.ICO" alt="Represents the border of an object." width="16" height="16" onclick="getHelp('xlobjBorder.htm');showMozHelp('Represents the border of an object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Color [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the color of the tick-mark labels on the value axis in Chart1." width="16" height="16" onclick="getHelp('xlproColor.htm')" onmouseover="showReturns('Returns: Object')"><br>ColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The following examples assume that you're using the default color palette." width="16" height="16" onclick="getHelp('xlproColorIndex.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>LineStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example puts a border around the chart area and the plot area of Chart1." width="16" height="16" onclick="getHelp('xlproLineStyle.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Weight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the border weight for oval one on Sheet1." width="16" height="16" onclick="getHelp('xlproWeight.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Borders (1995) <img src="MSGBOX02.ICO" alt="A collection of four Style object." width="16" height="16" onclick="getHelp('xlobjBorders.htm');showMozHelp('A collection of four Style object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Color [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the color of the tick-mark labels on the value axis in Chart1." width="16" height="16" onclick="getHelp('xlproColor.htm')" onmouseover="showReturns('Returns: Object')"><br>ColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The following examples assume that you're using the default color palette." width="16" height="16" onclick="getHelp('xlproColorIndex.htm')" onmouseover="showReturns('Returns: Object')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Border')"><br>LineStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example puts a border around the chart area and the plot area of Chart1." width="16" height="16" onclick="getHelp('xlproLineStyle.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Value [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. For the Application object, always returns &amp;quot;Microsoft Excel&amp;quot;. For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String." width="16" height="16" onclick="getHelp('xlproValue.htm')" onmouseover="showReturns('Returns: Object')"><br>Weight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the border weight for oval one on Sheet1." width="16" height="16" onclick="getHelp('xlproWeight.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>CalloutFormat (1997) <img src="MSGBOX02.ICO" alt="Contains properties and methods that apply to line callouts." width="16" height="16" onclick="getHelp('xlobjCalloutFormat.htm');showMozHelp('Contains properties and methods that apply to line callouts.');"></h2>Accent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. This example adds to myDocument an oval and a callout that points to the oval. The callout text wont have a border, but it will have a vertical accent bar that separates the text from the callout line." width="16" height="16" onclick="getHelp('xlproAccent.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Angle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoCalloutAngleType. If you set the value of this property to anything other than msoCalloutAngleAutomatic, the callout line maintains a fixed angle as you drag the callout." width="16" height="16" onclick="getHelp('xlproAngle.htm')" onmouseover="showReturns('Returns: MsoCalloutAngleType')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoAttach [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. When the value of this property is True, the drop value (the vertical distance from the edge of the callout text box to the place where the callout line attaches) is measured from the top of the text box when the text box is to the right of the origin, and its measured from the bottom of the text box when the text box is to the left of the origin. When the value of this property is False, the drop value is always measured from the top of the text box, regardless of the relative positions of the text box and the origin. Use the Drop property to return the drop value." width="16" height="16" onclick="getHelp('xlproAutoAttach.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>AutoLength<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour). Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproAutoLength.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>AutomaticLength() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Specifies that the first segment of the callout line (the segment attached to the text callout box) be scaled automatically when the callout is moved. Use the Length property whenever the callout is moved. Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour)." width="16" height="16" onclick="getHelp('xlmthAutomaticLength.htm')" onmouseover="showReturns('Returns: Void')"><br>Border [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>CustomDrop(Drop) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. This distance is measured from the top of the text box unless the AutoAttach property is set to True and the text box is to the left of the origin of the callout line (the place that the callout points to), in which case the drop distance is measured from the bottom of the text box." width="16" height="16" onclick="getHelp('xlmthCustomDrop.htm')" onmouseover="showReturns('Returns: Void')"><br>CustomLength(Length) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Specifies that the first segment of the callout line (the segment attached to the text callout box) retain a fixed length whenever the callout is moved. Use the AutomaticLength method to specify that the first segment of the callout line be scaled automatically whenever the callout is moved. Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour)." width="16" height="16" onclick="getHelp('xlmthCustomLength.htm')" onmouseover="showReturns('Returns: Void')"><br>Drop<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. For callouts with an explicitly set drop value, this property returns the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. This distance is measured from the top of the text box unless the AutoAttach property is set to True and the text box is to the left of the origin of the callout line (the place that the callout points to), in which case the drop distance is measured from the bottom of the text box. Read-only Single." width="16" height="16" onclick="getHelp('xlproDrop.htm')" onmouseover="showReturns('Returns: Single')"><br>DropType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoCalloutDropType. If the callout drop type is msoCalloutDropCustom, the values of the AutoAttach properties and the relative positions of the callout text box and callout line origin (the place that the callout points to) are used to determine where the callout line attaches to the text box." width="16" height="16" onclick="getHelp('xlproDropType.htm')" onmouseover="showReturns('Returns: MsoCalloutDropType')"><br>Gap [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the horizontal distance (in points) between the end of the callout line and the text bounding box. Read/write Single." width="16" height="16" onclick="getHelp('xlproGap.htm')" onmouseover="showReturns('Returns: Single')"><br>Length<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. This property is read-only. Use the CustomLength method to set the value of this property for a CalloutFormat object." width="16" height="16" onclick="getHelp('xlproLength.htm')" onmouseover="showReturns('Returns: Single')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PresetDrop(DropType) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Specifies whether the callout line attaches to the top, bottom, or center of the callout text box or whether it attaches at a point thats a specified distance from the top or bottom of the text box." width="16" height="16" onclick="getHelp('xlmthPresetDrop.htm')" onmouseover="showReturns('Returns: Void')"><br>Type [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoCalloutType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoCalloutType')"><br><h2>ColorFormat (1997) <img src="MSGBOX02.ICO" alt="Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the SchemeColor property)." width="16" height="16" onclick="getHelp('xlobjColorFormat.htm');showMozHelp('Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the SchemeColor property).');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>RGB [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example sets the interior color of the range A1:A10 to the chart area foreground fill color on chart one." width="16" height="16" onclick="getHelp('xlproRGB.htm')" onmouseover="showReturns('Returns: Int32')"><br>SchemeColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproSchemeColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>TintAndShade [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets a Single that lightens or darkens the color of a specified shape. Read/write." width="16" height="16" onclick="getHelp('xlproTintAndShade.htm')" onmouseover="showReturns('Returns: Single')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoColorType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoColorType')"><br><h2>ConnectorFormat (1995) <img src="MSGBOX02.ICO" alt="Contains properties and methods that apply to connectors. A connector is a line that attaches two other shapes at points called connection sites. If you rearrange shapes that are connected, the geometry of the connector will be automatically adjusted so that the shapes remain connected." width="16" height="16" onclick="getHelp('xlobjConnectorFormat.htm');showMozHelp('Contains properties and methods that apply to connectors. A connector is a line that attaches two other shapes at points called connection sites. If you rearrange shapes that are connected, the geometry of the connector will be automatically adjusted so that the shapes remain connected.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>BeginConnect(ConnectedShape, ConnectionSite) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Attaches the beginning of the specified connector to a specified shape. If theres already a connection between the beginning of the connector and another shape, that connection is broken. If the beginning of the connector isnt already positioned at the specified connecting site, this method moves the beginning of the connector to the connecting site and adjusts the size and position of the connector. Use the EndConnect method to attach the end of the connector to a shape." width="16" height="16" onclick="getHelp('xlmthBeginConnect.htm')" onmouseover="showReturns('Returns: Void')"><br>BeginConnected<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. If shape three on oldBeginConnShape, and then disconnects the beginning of the connector from the shape." width="16" height="16" onclick="getHelp('xlproBeginConnected.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>BeginConnectedShape<input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Returns a Shape object that represents the shape that the beginning of the specified connector is attached to. Read-only." width="16" height="16" onclick="getHelp('xlproBeginConnectedShape.htm')" onmouseover="showReturns('Returns: Shape')"><br>BeginConnectionSite<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns an integer that specifies the connection site that the beginning of a connector is connected to. Read-only Long." width="16" height="16" onclick="getHelp('xlproBeginConnectionSite.htm')" onmouseover="showReturns('Returns: Int32')"><br>BeginDisconnect() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Detaches the beginning of the specified connector from the shape its attached to. This method doesnt alter the size or position of the connector: the beginning of the connector remains positioned at a connection site but is no longer connected. Use the EndDisconnect method to detach the end of the connector from a shape." width="16" height="16" onclick="getHelp('xlmthBeginDisconnect.htm')" onmouseover="showReturns('Returns: Void')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>EndConnect(ConnectedShape, ConnectionSite) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Attaches the end of the specified connector to a specified shape. If theres already a connection between the end of the connector and another shape, that connection is broken. If the end of the connector isnt already positioned at the specified connecting site, this method moves the end of the connector to the connecting site and adjusts the size and position of the connector. Use the BeginConnect method to attach the beginning of the connector to a shape." width="16" height="16" onclick="getHelp('xlmthEndConnect.htm')" onmouseover="showReturns('Returns: Void')"><br>EndConnected<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. If the end of the connector represented by shape three on oldEndConnShape, and then disconnects the end of the connector from the shape." width="16" height="16" onclick="getHelp('xlproEndConnected.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>EndConnectedShape<input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Returns a Shape object that represents the shape that the end of the specified connector is attached to. Read-only." width="16" height="16" onclick="getHelp('xlproEndConnectedShape.htm')" onmouseover="showReturns('Returns: Shape')"><br>EndConnectionSite<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns an integer that specifies the connection site that the end of a connector is connected to. Read-only Long." width="16" height="16" onclick="getHelp('xlproEndConnectionSite.htm')" onmouseover="showReturns('Returns: Int32')"><br>EndDisconnect() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Detaches the end of the specified connector from the shape its attached to. This method doesnt alter the size or position of the connector: the end of the connector remains positioned at a connection site but is no longer connected. Use the BeginDisconnect method to detach the beginning of the connector from a shape." width="16" height="16" onclick="getHelp('xlmthEndDisconnect.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Type [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoConnectorType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoConnectorType')"><br><h2>Diagram (2002) <img src="MSGBOX02.ICO" alt="Represents a diagram." width="16" height="16" onclick="getHelp('xlobjDiagram.htm');showMozHelp('Represents a diagram.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Sets or returns an constant indicating the automatic formatting state for a diagram.&amp;nbsp;Read/write." width="16" height="16" onclick="getHelp('xlproAutoFormat.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>AutoLayout [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Returns or sets an MsoTriState constant which determines the automatic positioning of the nodes and connectors in a diagram. Read/write." width="16" height="16" onclick="getHelp('xlproAutoLayout.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Convert(Type) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Converts the current diagram to a different diagram." width="16" height="16" onclick="getHelp('xlmthConvert.htm')" onmouseover="showReturns('Returns: Void')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>FitText() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Nodes<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNodes. Nodes property as it applies to the Diagram object." width="16" height="16" onclick="getHelp('xlproNodes.htm')" onmouseover="showReturns('Returns: DiagramNodes')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Reverse [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. MsoTrue reverses the nodes in a diagram. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproReverse.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoDiagramType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoDiagramType')"><br><h2>DiagramNode (2002) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlobjDiagramNode.htm');showMozHelp('Hidden or unsupported element.');"></h2>AddNode([pos], [nodeType]) <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Creates a diagram node. Returns a DiagramNode object that represents the new node." width="16" height="16" onclick="getHelp('xlmthAddNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Children<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNodeChildren. &amp;nbsp;Returns a DiagramNodeChildren object, representing the collection of child nodes of a particular node." width="16" height="16" onclick="getHelp('xlproChildren.htm')" onmouseover="showReturns('Returns: DiagramNodeChildren')"><br>CloneNode(copyChildren, pTargetNode, [pos]) <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Clones a diagram node. Returns a DiagramNode object representing the cloned node." width="16" height="16" onclick="getHelp('xlmthCloneNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Diagram<input type="image" src="MSGBOX02.ICO" alt="Returns: IMsoDiagram. Returns a Diagram object representing a diagram." width="16" height="16" onclick="getHelp('xlproDiagram.htm')" onmouseover="showReturns('Returns: IMsoDiagram')"><br>Layout [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoOrgChartLayoutType. Returns or sets an MsoOrgChartLayoutType constant to indicate the formatting of the child nodes of an organization chart. Read/write." width="16" height="16" onclick="getHelp('xlproLayout.htm')" onmouseover="showReturns('Returns: MsoOrgChartLayoutType')"><br>MoveNode(pTargetNode, pos) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves a diagram node and any of its child nodes, within a diagram." width="16" height="16" onclick="getHelp('xlmthMoveNode.htm')" onmouseover="showReturns('Returns: Void')"><br>NextNode() <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Selects the next diagram node in a series of nodes. Returns a DiagramNode object representing the newly-selected node." width="16" height="16" onclick="getHelp('xlmthNextNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PrevNode() <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Returns a DiagramNode object that represents the previous diagram node in a collection of diagram nodes." width="16" height="16" onclick="getHelp('xlmthPrevNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>ReplaceNode(pTargetNode) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Replaces a target diagram node with the source diagram node. The target diagram node is deleted, and the source diagram node, including any of its child nodes, are moved to where the target diagram node was." width="16" height="16" onclick="getHelp('xlmthReplaceNode.htm')" onmouseover="showReturns('Returns: Void')"><br>Root<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Returns the root DiagramNode object which the root diagram node belongs." width="16" height="16" onclick="getHelp('xlproRoot.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Shape<input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Returns a Shape object that represents the shape attached to the specified comment, diagram node, or hyperlink." width="16" height="16" onclick="getHelp('xlproShape.htm')" onmouseover="showReturns('Returns: Shape')"><br>SwapNode(pTargetNode, [swapChildren]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Swaps the source diagram node with a target diagram node." width="16" height="16" onclick="getHelp('xlmthSwapNode.htm')" onmouseover="showReturns('Returns: Void')"><br>TextShape<input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Returns a Shape object representing the shape of the text box associated with a diagram node." width="16" height="16" onclick="getHelp('xlproTextShape.htm')" onmouseover="showReturns('Returns: Shape')"><br>TransferChildren(pReceivingNode) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Transfers the child nodes of a source diagram node to a receiving diagram node." width="16" height="16" onclick="getHelp('xlmthTransferChildren.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>DiagramNodeChildren (2002) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlobjDiagramNodeChildren.htm');showMozHelp('Hidden or unsupported element.');"></h2>AddNode([Index], [nodeType]) <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Creates a diagram node. Returns a DiagramNode object that represents the new node." width="16" height="16" onclick="getHelp('xlmthAddNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>FirstChild<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Returns a DiagramNode object that represents the first child node of a parent node." width="16" height="16" onclick="getHelp('xlproFirstChild.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>LastChild<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Returns a DiagramNode object that represents the last child node of a parent node." width="16" height="16" onclick="getHelp('xlproLastChild.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>SelectAll() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects all the shapes in the specified CanvasShapes, DiagramNodeChildren, DiagramNodes, or Shapes collection." width="16" height="16" onclick="getHelp('xlmthSelectAll.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>DiagramNodes (2002) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlobjDiagramNodes.htm');showMozHelp('Hidden or unsupported element.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>SelectAll() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects all the shapes in the specified CanvasShapes, DiagramNodeChildren, DiagramNodes, or Shapes collection." width="16" height="16" onclick="getHelp('xlmthSelectAll.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>FillFormat (1997) <img src="MSGBOX02.ICO" alt="Represents fill formatting for a shape. A shape can have a solid, gradient, texture, pattern, picture, or semi-transparent fill." width="16" height="16" onclick="getHelp('xlobjFillFormat.htm');showMozHelp('Represents fill formatting for a shape. A shape can have a solid, gradient, texture, pattern, picture, or semi-transparent fill.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>BackColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: ColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproBackColor.htm')" onmouseover="showReturns('Returns: ColorFormat')"><br>Background() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>ForeColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: ColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproForeColor.htm')" onmouseover="showReturns('Returns: ColorFormat')"><br>GradientColorType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoGradientColorType. This example sets the fill format for chart two to the same style used for chart one." width="16" height="16" onclick="getHelp('xlproGradientColorType.htm')" onmouseover="showReturns('Returns: MsoGradientColorType')"><br>GradientDegree<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns the gradient degree of the specified one-color shaded fill as a floating-point value from 0.0 (dark) through 1.0 (light). Read-only Single." width="16" height="16" onclick="getHelp('xlproGradientDegree.htm')" onmouseover="showReturns('Returns: Single')"><br>GradientStyle<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoGradientStyle. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: MsoGradientStyle')"><br>GradientVariant<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the shade variant for the specified fill as an integer value from 1 through 4. The values for this property correspond to the gradient variants (numbered from left to right and from top to bottom) on the Gradient tab in the Fill Effects dialog box. Read-only Long." width="16" height="16" onclick="getHelp('xlproGradientVariant.htm')" onmouseover="showReturns('Returns: Int32')"><br>OneColorGradient(Style, Variant, Degree) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example sets the fill format for chart two to the same style used for chart one." width="16" height="16" onclick="getHelp('xlmthOneColorGradient.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Pattern<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPatternType. This example adds a crisscross pattern to the interior of cell A1 on Sheet1." width="16" height="16" onclick="getHelp('xlproPattern.htm')" onmouseover="showReturns('Returns: MsoPatternType')"><br>Patterned(Pattern) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example sets the fill pattern for chart one." width="16" height="16" onclick="getHelp('xlmthPatterned.htm')" onmouseover="showReturns('Returns: Void')"><br>PresetGradient(Style, Variant, PresetGradientType) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill to a preset gradient." width="16" height="16" onclick="getHelp('xlmthPresetGradient.htm')" onmouseover="showReturns('Returns: Void')"><br>PresetGradientType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetGradientType. Use the PresetGradient method to set the preset gradient type for the fill." width="16" height="16" onclick="getHelp('xlproPresetGradientType.htm')" onmouseover="showReturns('Returns: MsoPresetGradientType')"><br>PresetTexture<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetTexture. Use the PresetTextured method to set the preset texture for the fill." width="16" height="16" onclick="getHelp('xlproPresetTexture.htm')" onmouseover="showReturns('Returns: MsoPresetTexture')"><br>PresetTextured(PresetTexture) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill format to a preset texture." width="16" height="16" onclick="getHelp('xlmthPresetTextured.htm')" onmouseover="showReturns('Returns: Void')"><br>Solid() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill to a uniform color. Use this method to convert a gradient, textured, patterned, or background fill back to a solid fill." width="16" height="16" onclick="getHelp('xlmthSolid.htm')" onmouseover="showReturns('Returns: Void')"><br>TextureName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name of the custom texture file for the specified fill. Read-only String." width="16" height="16" onclick="getHelp('xlproTextureName.htm')" onmouseover="showReturns('Returns: String')"><br>TextureType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTextureType. Use the UserTextured method to set the texture type for the fill." width="16" height="16" onclick="getHelp('xlproTextureType.htm')" onmouseover="showReturns('Returns: MsoTextureType')"><br>Transparency [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear). Read/write Double." width="16" height="16" onclick="getHelp('xlproTransparency.htm')" onmouseover="showReturns('Returns: Single')"><br>TwoColorGradient(Style, Variant) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill to a two-color gradient." width="16" height="16" onclick="getHelp('xlmthTwoColorGradient.htm')" onmouseover="showReturns('Returns: Void')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoFillType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoFillType')"><br>UserPicture(PictureFile) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Fills the specified shape with an image." width="16" height="16" onclick="getHelp('xlmthUserPicture.htm')" onmouseover="showReturns('Returns: Void')"><br>UserTextured(TextureFile) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Fills the specified shape with small tiles of an image. If you want to fill the shape with one large image, use the UserPicture method." width="16" height="16" onclick="getHelp('xlmthUserTextured.htm')" onmouseover="showReturns('Returns: Void')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br><h2>FreeformBuilder (1997) <img src="MSGBOX02.ICO" alt="Represents the geometry of a freeform while its being built." width="16" height="16" onclick="getHelp('xlobjFreeformBuilder.htm');showMozHelp('Represents the geometry of a freeform while its being built.');"></h2>AddNodes(SegmentType, EditingType, X1, Y1, [X2], [Y2], [X3], [Y3]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example adds a freeform with four segments to myDocument." width="16" height="16" onclick="getHelp('xlmthAddNodes.htm')" onmouseover="showReturns('Returns: Void')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>ConvertToShape() <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a shape that has the geometric characteristics of the specified FreeformBuilder object. Returns a Shape object that represents the new shape." width="16" height="16" onclick="getHelp('xlmthConvertToShape.htm')" onmouseover="showReturns('Returns: Shape')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>GroupShapes (1997) <img src="MSGBOX02.ICO" alt="Represents the individual shapes within a grouped shape. Each shape is represented by a Item method with this object, you can work with single shapes within a group without having to ungroup them." width="16" height="16" onclick="getHelp('xlobjGroupShapes.htm');showMozHelp('Represents the individual shapes within a grouped shape. Each shape is represented by a Item method with this object, you can work with single shapes within a group without having to ungroup them.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Shape')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: ShapeRange')"><br><h2>Interior (1995) <img src="MSGBOX02.ICO" alt="Represents the interior of an object." width="16" height="16" onclick="getHelp('xlobjInterior.htm');showMozHelp('Represents the interior of an object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Color [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets the color of the tick-mark labels on the value axis in Chart1." width="16" height="16" onclick="getHelp('xlproColor.htm')" onmouseover="showReturns('Returns: Object')"><br>ColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The following examples assume that you're using the default color palette." width="16" height="16" onclick="getHelp('xlproColorIndex.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>InvertIfNegative [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Variant for the Interior object, read/write Boolean for all other objects." width="16" height="16" onclick="getHelp('xlproInvertIfNegative.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Pattern [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example adds a crisscross pattern to the interior of cell A1 on Sheet1." width="16" height="16" onclick="getHelp('xlproPattern.htm')" onmouseover="showReturns('Returns: Object')"><br>PatternColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the color of the interior pattern as an RGB value. Read/write Variant." width="16" height="16" onclick="getHelp('xlproPatternColor.htm')" onmouseover="showReturns('Returns: Object')"><br>PatternColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the color of the interior pattern as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Read/write Long." width="16" height="16" onclick="getHelp('xlproPatternColorIndex.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>LineFormat (1997) <img src="MSGBOX02.ICO" alt="Represents line and arrowhead formatting. For a line, the LineFormat object contains formatting information for the line itself; for a shape with a border, this object contains formatting information for the shape border." width="16" height="16" onclick="getHelp('xlobjLineFormat.htm');showMozHelp('Represents line and arrowhead formatting. For a line, the LineFormat object contains formatting information for the line itself; for a shape with a border, this object contains formatting information for the shape border.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>BackColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: ColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproBackColor.htm')" onmouseover="showReturns('Returns: ColorFormat')"><br>BeginArrowheadLength [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoArrowheadLength. This example adds a line to myDocument. Theres a short, narrow oval on the line's starting point and a long, wide triangle on its end point." width="16" height="16" onclick="getHelp('xlproBeginArrowheadLength.htm')" onmouseover="showReturns('Returns: MsoArrowheadLength')"><br>BeginArrowheadStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoArrowheadStyle. This example adds a line to myDocument. Theres a short, narrow oval on the line's starting point and a long, wide triangle on its end point." width="16" height="16" onclick="getHelp('xlproBeginArrowheadStyle.htm')" onmouseover="showReturns('Returns: MsoArrowheadStyle')"><br>BeginArrowheadWidth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoArrowheadWidth. This example adds a line to myDocument. Theres a short, narrow oval on the line's starting point and a long, wide triangle on its end point." width="16" height="16" onclick="getHelp('xlproBeginArrowheadWidth.htm')" onmouseover="showReturns('Returns: MsoArrowheadWidth')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>DashStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoLineDashStyle. This example adds a blue dashed line to myDocument." width="16" height="16" onclick="getHelp('xlproDashStyle.htm')" onmouseover="showReturns('Returns: MsoLineDashStyle')"><br>EndArrowheadLength [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoArrowheadLength. This example adds a line to myDocument. Theres a short, narrow oval on the line's starting point and a long, wide triangle on its end point." width="16" height="16" onclick="getHelp('xlproEndArrowheadLength.htm')" onmouseover="showReturns('Returns: MsoArrowheadLength')"><br>EndArrowheadStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoArrowheadStyle. This example adds a line to myDocument. Theres a short, narrow oval on the line's starting point and a long, wide triangle on its end point." width="16" height="16" onclick="getHelp('xlproEndArrowheadStyle.htm')" onmouseover="showReturns('Returns: MsoArrowheadStyle')"><br>EndArrowheadWidth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoArrowheadWidth. This example adds a line to myDocument. Theres a short, narrow oval on the line's starting point and a long, wide triangle on its end point." width="16" height="16" onclick="getHelp('xlproEndArrowheadWidth.htm')" onmouseover="showReturns('Returns: MsoArrowheadWidth')"><br>ForeColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: ColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproForeColor.htm')" onmouseover="showReturns('Returns: ColorFormat')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Pattern [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPatternType. This example adds a crisscross pattern to the interior of cell A1 on Sheet1." width="16" height="16" onclick="getHelp('xlproPattern.htm')" onmouseover="showReturns('Returns: MsoPatternType')"><br>Style [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoLineStyle. &amp;nbsp;Style property as it applies to the LineFormat object." width="16" height="16" onclick="getHelp('xlproStyle.htm')" onmouseover="showReturns('Returns: MsoLineStyle')"><br>Transparency [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear). Read/write Double." width="16" height="16" onclick="getHelp('xlproTransparency.htm')" onmouseover="showReturns('Returns: Single')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Weight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. This example sets the border weight for oval one on Sheet1." width="16" height="16" onclick="getHelp('xlproWeight.htm')" onmouseover="showReturns('Returns: Single')"><br><h2>LinkFormat (1995) <img src="MSGBOX02.ICO" alt="Contains linked OLE object properties." width="16" height="16" onclick="getHelp('xlobjLinkFormat.htm');showMozHelp('Contains linked OLE object properties.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoUpdate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the OLE object is updated automatically when the source changes. Valid only if the object is linked (its OLEType property must be xlOLELink). Read-only Boolean." width="16" height="16" onclick="getHelp('xlproAutoUpdate.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Locked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Locked property as it applies to the ChartObject, ChartObjects, LinkFormat, OLEObject, OLEObjects, Scenario, Shape, and Style objects." width="16" height="16" onclick="getHelp('xlproLocked.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Update() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Updates the link or PivotTable report." width="16" height="16" onclick="getHelp('xlmthUpdate.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>PictureFormat (1997) <img src="MSGBOX02.ICO" alt="Contains properties and methods that apply to pictures and OLE objects. The OLEFormat object contains properties and methods that apply to OLE objects whether or not theyre linked." width="16" height="16" onclick="getHelp('xlobjPictureFormat.htm');showMozHelp('Contains properties and methods that apply to pictures and OLE objects. The OLEFormat object contains properties and methods that apply to OLE objects whether or not theyre linked.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Brightness [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the brightness of the specified picture or OLE object. The value for this property must be a number from 0.0 (dimmest) to 1.0 (brightest). Read/write Single." width="16" height="16" onclick="getHelp('xlproBrightness.htm')" onmouseover="showReturns('Returns: Single')"><br>ColorType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPictureColorType. This example sets the color transformation to grayscale for shape one on myDocument. Shape one must be either a picture or an OLE object." width="16" height="16" onclick="getHelp('xlproColorType.htm')" onmouseover="showReturns('Returns: MsoPictureColorType')"><br>Contrast [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the contrast for the specified picture or OLE object. The value for this property must be a number from 0.0 (the least contrast) to 1.0 (the greatest contrast). Read/write Single." width="16" height="16" onclick="getHelp('xlproContrast.htm')" onmouseover="showReturns('Returns: Single')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>CropBottom [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the number of points that are cropped off the bottom of the specified picture or OLE object. Read/write Single." width="16" height="16" onclick="getHelp('xlproCropBottom.htm')" onmouseover="showReturns('Returns: Single')"><br>CropLeft [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the number of points that are cropped off the left side of the specified picture or OLE object. Read/write Single." width="16" height="16" onclick="getHelp('xlproCropLeft.htm')" onmouseover="showReturns('Returns: Single')"><br>CropRight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the number of points that are cropped off the right side of the specified picture or OLE object. Read/write Single." width="16" height="16" onclick="getHelp('xlproCropRight.htm')" onmouseover="showReturns('Returns: Single')"><br>CropTop [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the number of points that are cropped off the top of the specified picture or OLE object. Read/write Single." width="16" height="16" onclick="getHelp('xlproCropTop.htm')" onmouseover="showReturns('Returns: Single')"><br>IncrementBrightness(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the brightness of the picture by the specified amount. Use the Brightness property to set the absolute brightness of the picture." width="16" height="16" onclick="getHelp('xlmthIncrementBrightness.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementContrast(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the contrast of the picture by the specified amount. Use the Contrast property to set the absolute contrast for the picture." width="16" height="16" onclick="getHelp('xlmthIncrementContrast.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>TransparencyColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the transparent color for the specified picture as a red-green-blue (RGB) value. For this property to take effect, the TransparentBackground property must be set to True. Applies to bitmaps only. Read/write Long." width="16" height="16" onclick="getHelp('xlproTransparencyColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>TransparentBackground [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Use the TransparencyColor property to set the transparent color. Applies to bitmaps only. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproTransparentBackground.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br><h2>Point (1995) <img src="MSGBOX02.ICO" alt="Represents a single point in a series in a chart. The Point object is a member of the Points collection. The Points collection contains all the points in one series." width="16" height="16" onclick="getHelp('xlobjPoint.htm');showMozHelp('Represents a single point in a series in a chart. The Point object is a member of the Points collection. The Points collection contains all the points in one series.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example applies category labels to series one in Chart1." width="16" height="16" onclick="getHelp('xlmthApplyDataLabels.htm')" onmouseover="showReturns('Returns: Object')"><br>ApplyPictToEnd [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if a picture is applied to the end of the point or all points in the series. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproApplyPictToEnd.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ApplyPictToFront [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if a picture is applied to the front of the point or all points in the series. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproApplyPictToFront.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ApplyPictToSides [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if a picture is applied to the sides of the point or all points in the series. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproApplyPictToSides.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Copy() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Copies the range to the specified range or to the Clipboard." width="16" height="16" onclick="getHelp('xlmthCopy.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>DataLabel<input type="image" src="MSGBOX02.ICO" alt="Returns: DataLabel. Returns a DataLabel object that represents the data label associated with the point or trendline. Read-only." width="16" height="16" onclick="getHelp('xlproDataLabel.htm')" onmouseover="showReturns('Returns: DataLabel')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Explosion [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie). Read/write Long." width="16" height="16" onclick="getHelp('xlproExplosion.htm')" onmouseover="showReturns('Returns: Int32')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>HasDataLabel [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the point has a data label. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproHasDataLabel.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>InvertIfNegative [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Variant for the Interior object, read/write Boolean for all other objects." width="16" height="16" onclick="getHelp('xlproInvertIfNegative.htm')" onmouseover="showReturns('Returns: Boolean')"><br>MarkerBackgroundColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the marker background color as an RGB value. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerBackgroundColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>MarkerBackgroundColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. Returns or sets the marker background color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerBackgroundColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><br>MarkerForegroundColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the foreground color of the marker as an RGB value. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerForegroundColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>MarkerForegroundColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. Returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerForegroundColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><br>MarkerSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the data-marker size, in points. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerSize.htm')" onmouseover="showReturns('Returns: Int32')"><br>MarkerStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlMarkerStyle. This example sets the marker style for series one in Chart1. The example should be run on a 2-D line chart." width="16" height="16" onclick="getHelp('xlproMarkerStyle.htm')" onmouseover="showReturns('Returns: XlMarkerStyle')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Paste() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Pastes chart data from the Clipboard into the specified chart." width="16" height="16" onclick="getHelp('xlmthPaste.htm')" onmouseover="showReturns('Returns: Object')"><br>PictureType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlChartPictureType. This example sets series one in Chart1 to stretch pictures. The example should be run on a 2-D column chart with picture data markers." width="16" height="16" onclick="getHelp('xlproPictureType.htm')" onmouseover="showReturns('Returns: XlChartPictureType')"><br>PictureUnit [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the unit for each picture on the chart if the PictureType property is set to xlScale (if not, this property is ignored). Read/write Long." width="16" height="16" onclick="getHelp('xlproPictureUnit.htm')" onmouseover="showReturns('Returns: Int32')"><br>SecondaryPlot [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the point is in the secondary section of either a pie of pie chart or a bar of pie chart. Applies only to points on pie of pie charts or bar of pie charts. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproSecondaryPlot.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Shadow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Points (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Point objects in the specified series in a chart." width="16" height="16" onclick="getHelp('xlobjPoints.htm');showMozHelp('A collection of all the Point objects in the specified series in a chart.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Point. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Point')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>ShadowFormat (1997) <img src="MSGBOX02.ICO" alt="Represents shadow formatting for a shape." width="16" height="16" onclick="getHelp('xlobjShadowFormat.htm');showMozHelp('Represents shadow formatting for a shape.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>ForeColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: ColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproForeColor.htm')" onmouseover="showReturns('Returns: ColorFormat')"><br>IncrementOffsetX(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the horizontal offset of the shadow by the specified number of points. Use the OffsetX property to set the absolute horizontal shadow offset." width="16" height="16" onclick="getHelp('xlmthIncrementOffsetX.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementOffsetY(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the vertical offset of the shadow by the specified number of points. Use the OffsetY property to set the absolute vertical shadow offset." width="16" height="16" onclick="getHelp('xlmthIncrementOffsetY.htm')" onmouseover="showReturns('Returns: Void')"><br>Obscured [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the shadow of the specified shape appears filled in and is obscured by the shape, even if the shape has no fill. False if the shadow has no fill and the outline of the shadow is visible through the shape if the shape has no fill. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproObscured.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>OffsetX [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the horizontal offset of the shadow from the specified shape, in points. A positive value offsets the shadow to the right of the shape; a negative value offsets it to the left. Read/write Single." width="16" height="16" onclick="getHelp('xlproOffsetX.htm')" onmouseover="showReturns('Returns: Single')"><br>OffsetY [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the vertical offset of the shadow from the specified shape, in points. A positive value offsets the shadow to the right of the shape; a negative value offsets it to the left. Read/write Single." width="16" height="16" onclick="getHelp('xlproOffsetY.htm')" onmouseover="showReturns('Returns: Single')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Transparency [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear). Read/write Double." width="16" height="16" onclick="getHelp('xlproTransparency.htm')" onmouseover="showReturns('Returns: Single')"><br>Type [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoShadowType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoShadowType')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br><h2>Shape (1997) <img src="MSGBOX02.ICO" alt="Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide." width="16" height="16" onclick="getHelp('xlobjShape.htm');showMozHelp('Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.');"></h2>Adjustments<input type="image" src="MSGBOX02.ICO" alt="Returns: Adjustments. Returns an Adjustments object that contains adjustment values for all the adjustments in the specified shape. Applies to any Shape or ShapeRange object that represents an AutoShape, WordArt, or a connector. Read-only." width="16" height="16" onclick="getHelp('xlproAdjustments.htm')" onmouseover="showReturns('Returns: Adjustments')"><br>AlternativeText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the descriptive (alternative) text string for a ShapeRange object when the object is saved to a Web page. Read/write String." width="16" height="16" onclick="getHelp('xlproAlternativeText.htm')" onmouseover="showReturns('Returns: String')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Apply() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Applies to the specified shape formatting thats been copied by using the PickUp method." width="16" height="16" onclick="getHelp('xlmthApply.htm')" onmouseover="showReturns('Returns: Void')"><br>AutoShapeType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoAutoShapeType. Use the Type property of the ConnectorFormat object to set or return the connector type." width="16" height="16" onclick="getHelp('xlproAutoShapeType.htm')" onmouseover="showReturns('Returns: MsoAutoShapeType')"><br>BlackWhiteMode [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoBlackWhiteMode. This example sets shape one on wksOne to appear in black-and-white mode. When you view the presentation in black-and-white mode, shape one will appear black regardless of what color it is in color mode." width="16" height="16" onclick="getHelp('xlproBlackWhiteMode.htm')" onmouseover="showReturns('Returns: MsoBlackWhiteMode')"><br>BottomRightCell<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the cell that lies under the lower-right corner of the object. Read-only." width="16" height="16" onclick="getHelp('xlproBottomRightCell.htm')" onmouseover="showReturns('Returns: Range')"><br>Callout<input type="image" src="MSGBOX02.ICO" alt="Returns: CalloutFormat. Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to Shape or ShapeRange objects that represent line callouts. Read-only." width="16" height="16" onclick="getHelp('xlproCallout.htm')" onmouseover="showReturns('Returns: CalloutFormat')"><br>CanvasCropBottom(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasCropLeft(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasCropRight(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasCropTop(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasItems<input type="image" src="MSGBOX02.ICO" alt="Returns: CanvasShapes. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: CanvasShapes')"><br>Child<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Returns msoTrue if the specified shape is a child shape or if all shapes in a shape range are child shapes of the same parent.&amp;nbsp;Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproChild.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>ConnectionSiteCount<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the number of connection sites on the specified shape. Read-only Long." width="16" height="16" onclick="getHelp('xlproConnectionSiteCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Connector<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. This example deletes all connectors on myDocument." width="16" height="16" onclick="getHelp('xlproConnector.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>ConnectorFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: ConnectorFormat. Returns a ConnectorFormat object that contains connector formatting properties. Applies to Shape or ShapeRange objects that represent connectors. Read-only." width="16" height="16" onclick="getHelp('xlproConnectorFormat.htm')" onmouseover="showReturns('Returns: ConnectorFormat')"><br>ControlFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: ControlFormat. Returns a Microsoft Excel control properties. Read-only." width="16" height="16" onclick="getHelp('xlproControlFormat.htm')" onmouseover="showReturns('Returns: ControlFormat')"><br>Copy() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Copies the range to the specified range or to the Clipboard." width="16" height="16" onclick="getHelp('xlmthCopy.htm')" onmouseover="showReturns('Returns: Void')"><br>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.htm')" onmouseover="showReturns('Returns: Void')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Cut() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Void')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Diagram<input type="image" src="MSGBOX02.ICO" alt="Returns: Diagram. Returns a Diagram object representing a diagram." width="16" height="16" onclick="getHelp('xlproDiagram.htm')" onmouseover="showReturns('Returns: Diagram')"><br>DiagramNode<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Returns a DiagramNode object that represents a node in a diagram." width="16" height="16" onclick="getHelp('xlproDiagramNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>DrawingObject<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: Shape')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: FillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: FillFormat')"><br>Flip(FlipCmd) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example adds a triangle to myDocument, duplicates the triangle, and then flips the duplicate triangle vertically and makes it red." width="16" height="16" onclick="getHelp('xlmthFlip.htm')" onmouseover="showReturns('Returns: Void')"><br>FormControlType<input type="image" src="MSGBOX02.ICO" alt="Returns: XlFormControl. You cannot use this property with ActiveX controls (the Type property for the Shape object must return msoFormControl)." width="16" height="16" onclick="getHelp('xlproFormControlType.htm')" onmouseover="showReturns('Returns: XlFormControl')"><br>GroupItems<input type="image" src="MSGBOX02.ICO" alt="Returns: GroupShapes. Returns a Item method of the GroupShapes object to return a single shape from the group. Applies to Shape or ShapeRange objects that represent grouped shapes. Read-only." width="16" height="16" onclick="getHelp('xlproGroupItems.htm')" onmouseover="showReturns('Returns: GroupShapes')"><br>HasDiagram<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. &amp;nbsp;Returns whether a shape or shape range contains a diagram. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproHasDiagram.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>HasDiagramNode<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Returns whether a diagram node exists in a given shape or shape range. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproHasDiagramNode.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Single')"><br>HorizontalFlip<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the specified shape is flipped around the horizontal axis. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproHorizontalFlip.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Hyperlink<input type="image" src="MSGBOX02.ICO" alt="Returns: Hyperlink. Returns a Hyperlink object that represents the hyperlink for the shape." width="16" height="16" onclick="getHelp('xlproHyperlink.htm')" onmouseover="showReturns('Returns: Hyperlink')"><br>ID<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the type for the specified object. Read-only Long." width="16" height="16" onclick="getHelp('xlproID.htm')" onmouseover="showReturns('Returns: Int32')"><br>IncrementLeft(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the specified shape horizontally by the specified number of points." width="16" height="16" onclick="getHelp('xlmthIncrementLeft.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementRotation(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the rotation of the specified shape around the z-axis by the specified number of degrees. Use the Rotation property to set the absolute rotation of the shape." width="16" height="16" onclick="getHelp('xlmthIncrementRotation.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementTop(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the specified shape vertically by the specified number of points." width="16" height="16" onclick="getHelp('xlmthIncrementTop.htm')" onmouseover="showReturns('Returns: Void')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Single')"><br>Line<input type="image" src="MSGBOX02.ICO" alt="Returns: LineFormat. Returns a LineFormat object that contains line formatting properties for the specified shape. (For a line, the LineFormat object represents the line itself; for a shape with a border, the LineFormat object represents the border.) Read-only." width="16" height="16" onclick="getHelp('xlproLine.htm')" onmouseover="showReturns('Returns: LineFormat')"><br>LinkFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: LinkFormat. Returns a LinkFormat object that contains linked OLE object properties. Read-only." width="16" height="16" onclick="getHelp('xlproLinkFormat.htm')" onmouseover="showReturns('Returns: LinkFormat')"><br>LockAspectRatio [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the specified shape retains its original proportions when you resize it. False if you can change the height and width of the shape independently of one another when you resize it. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproLockAspectRatio.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Locked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Locked property as it applies to the ChartObject, ChartObjects, LinkFormat, OLEObject, OLEObjects, Scenario, Shape, and Style objects." width="16" height="16" onclick="getHelp('xlproLocked.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Nodes<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeNodes. Nodes property as it applies to the Diagram object." width="16" height="16" onclick="getHelp('xlproNodes.htm')" onmouseover="showReturns('Returns: ShapeNodes')"><br>OLEFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: OLEFormat. Returns an OLEFormat object that contains OLE object properties. Read-only." width="16" height="16" onclick="getHelp('xlproOLEFormat.htm')" onmouseover="showReturns('Returns: OLEFormat')"><br>OnAction [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of a macro thats run when the specified object is clicked. Read/write String." width="16" height="16" onclick="getHelp('xlproOnAction.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>ParentGroup<input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes." width="16" height="16" onclick="getHelp('xlproParentGroup.htm')" onmouseover="showReturns('Returns: Shape')"><br>PickUp() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape." width="16" height="16" onclick="getHelp('xlmthPickUp.htm')" onmouseover="showReturns('Returns: Void')"><br>PictureFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: PictureFormat. Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to Shape or ShapeRange objects that represent pictures or OLE objects. Read-only." width="16" height="16" onclick="getHelp('xlproPictureFormat.htm')" onmouseover="showReturns('Returns: PictureFormat')"><br>Placement [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlPlacement. This example sets embedded chart one on Sheet1 to be free-floating (it neither moves nor is sized with its underlying cells)." width="16" height="16" onclick="getHelp('xlproPlacement.htm')" onmouseover="showReturns('Returns: XlPlacement')"><br>RerouteConnections() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Reroutes connectors so that they take the shortest possible path between the shapes they connect. To do this, the RerouteConnections method may detach the ends of a connector and reattach them to different connecting sites on the connected shapes." width="16" height="16" onclick="getHelp('xlmthRerouteConnections.htm')" onmouseover="showReturns('Returns: Void')"><br>Rotation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Chart object: Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts. Read/write Variant." width="16" height="16" onclick="getHelp('xlproRotation.htm')" onmouseover="showReturns('Returns: Single')"><br>ScaleHeight(Factor, RelativeToOriginalSize, [Scale]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Scales the height of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current height." width="16" height="16" onclick="getHelp('xlmthScaleHeight.htm')" onmouseover="showReturns('Returns: Void')"><br>ScaleWidth(Factor, RelativeToOriginalSize, [Scale]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Scales the width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current width." width="16" height="16" onclick="getHelp('xlmthScaleWidth.htm')" onmouseover="showReturns('Returns: Void')"><br>Script<input type="image" src="MSGBOX02.ICO" alt="Returns: Script. Returns the Script object, which represents a block of script or code on the specified Web page. If the page contains no script, nothing is returned." width="16" height="16" onclick="getHelp('xlproScript.htm')" onmouseover="showReturns('Returns: Script')"><br>Select([Replace]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Void')"><br>SetShapesDefaultProperties() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Makes the formatting of the specified shape the default formatting for the shape." width="16" height="16" onclick="getHelp('xlmthSetShapesDefaultProperties.htm')" onmouseover="showReturns('Returns: Void')"><br>Shadow<input type="image" src="MSGBOX02.ICO" alt="Returns: ShadowFormat. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: ShadowFormat')"><br>TextEffect<input type="image" src="MSGBOX02.ICO" alt="Returns: TextEffectFormat. Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape or ShapeRange objects that represent WordArt. Read-only." width="16" height="16" onclick="getHelp('xlproTextEffect.htm')" onmouseover="showReturns('Returns: TextEffectFormat')"><br>TextFrame<input type="image" src="MSGBOX02.ICO" alt="Returns: TextFrame. Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only." width="16" height="16" onclick="getHelp('xlproTextFrame.htm')" onmouseover="showReturns('Returns: TextFrame')"><br>ThreeD<input type="image" src="MSGBOX02.ICO" alt="Returns: ThreeDFormat. Returns a ThreeDFormat object that contains 3-D&amp;nbsp;&amp;nbsp;effect formatting properties for the specified shape. Read-only." width="16" height="16" onclick="getHelp('xlproThreeD.htm')" onmouseover="showReturns('Returns: ThreeDFormat')"><br>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Single')"><br>TopLeftCell<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the cell that lies under the upper-left corner of the specified object. Read-only." width="16" height="16" onclick="getHelp('xlproTopLeftCell.htm')" onmouseover="showReturns('Returns: Range')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoShapeType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoShapeType')"><br>Ungroup() <input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. This example ungroups any grouped shapes and disassembles any pictures or OLE objects on myDocument." width="16" height="16" onclick="getHelp('xlmthUngroup.htm')" onmouseover="showReturns('Returns: ShapeRange')"><br>VerticalFlip<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the specified shape is flipped around the vertical axis. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproVerticalFlip.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Vertices<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the coordinates of the specified freeform drawing's vertices (and control points for Bzier curves) as a series of AddPolyLine method. Read-only Variant." width="16" height="16" onclick="getHelp('xlproVertices.htm')" onmouseover="showReturns('Returns: Object')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Single')"><br>ZOrder(ZOrderCmd) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the specified shape in front of or behind other shapes in the collection (that is, changes the shape's position in the z-order)." width="16" height="16" onclick="getHelp('xlmthZOrder.htm')" onmouseover="showReturns('Returns: Void')"><br>ZOrderPosition<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>ShapeNode (1997) <img src="MSGBOX02.ICO" alt="Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform. Nodes include the vertices between the segments of the freeform and the control points for curved segments. The ShapeNode object is a member of the ShapeNodes collection. The ShapeNodes collection contains all the nodes in a freeform." width="16" height="16" onclick="getHelp('xlobjShapeNode.htm');showMozHelp('Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform. Nodes include the vertices between the segments of the freeform and the control points for curved segments. The ShapeNode object is a member of the ShapeNodes collection. The ShapeNodes collection contains all the nodes in a freeform.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>EditingType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoEditingType. This property is read-only. Use the SetEditingType method to set the value of this property." width="16" height="16" onclick="getHelp('xlproEditingType.htm')" onmouseover="showReturns('Returns: MsoEditingType')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Points<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the position of the specified node as a coordinate pair. Each coordinate is expressed in points. Read-only Variant." width="16" height="16" onclick="getHelp('xlproPoints.htm')" onmouseover="showReturns('Returns: Object')"><br>SegmentType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoSegmentType. Use the SetSegmentType method to set the value of this property." width="16" height="16" onclick="getHelp('xlproSegmentType.htm')" onmouseover="showReturns('Returns: MsoSegmentType')"><br><h2>ShapeNodes (1997) <img src="MSGBOX02.ICO" alt="A collection of all the ConvertToShape methods." width="16" height="16" onclick="getHelp('xlobjShapeNodes.htm');showMozHelp('A collection of all the ConvertToShape methods.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Delete(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Insert(Index, SegmentType, EditingType, X1, Y1, [X2], [Y2], [X3], [Y3]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space." width="16" height="16" onclick="getHelp('xlmthInsert.htm')" onmouseover="showReturns('Returns: Void')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeNode. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: ShapeNode')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>SetEditingType(Index, EditingType) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the editing type of the node specified by Index. If the node is a control point for a curved segment, this method sets the editing type of the node adjacent to it that joins two segments. Note that, depending on the editing type, this method may affect the position of adjacent nodes." width="16" height="16" onclick="getHelp('xlmthSetEditingType.htm')" onmouseover="showReturns('Returns: Void')"><br>SetPosition(Index, X1, Y1) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the location of the node specified by Index. Note that, depending on the editing type of the node, this method may affect the position of adjacent nodes." width="16" height="16" onclick="getHelp('xlmthSetPosition.htm')" onmouseover="showReturns('Returns: Void')"><br>SetSegmentType(Index, SegmentType) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the segment type of the segment that follows the node specified by Index. If the node is a control point for a curved segment, this method sets the segment type for that curve. Note that this may affect the total number of nodes by inserting or deleting adjacent nodes." width="16" height="16" onclick="getHelp('xlmthSetSegmentType.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>ShapeRange (1997) <img src="MSGBOX02.ICO" alt="Represents a shape range, which is a set of shapes on a document. A shape range can contain as few as a single shape or as many as all the shapes on the document. You can include whichever shapes you want&amp;nbsp; chosen from among all the shapes on the document or all the shapes in the selection&amp;nbsp; to construct a shape range. For example, you could construct a ShapeRange collection that contains the first three shapes on a document, all the selected shapes on a document, or all the freeforms on a document." width="16" height="16" onclick="getHelp('xlobjShapeRange.htm');showMozHelp('Represents a shape range, which is a set of shapes on a document. A shape range can contain as few as a single shape or as many as all the shapes on the document. You can include whichever shapes you want&amp;nbsp; chosen from among all the shapes on the document or all the shapes in the selection&amp;nbsp; to construct a shape range. For example, you could construct a ShapeRange collection that contains the first three shapes on a document, all the selected shapes on a document, or all the freeforms on a document.');"></h2>Adjustments<input type="image" src="MSGBOX02.ICO" alt="Returns: Adjustments. Returns an Adjustments object that contains adjustment values for all the adjustments in the specified shape. Applies to any Shape or ShapeRange object that represents an AutoShape, WordArt, or a connector. Read-only." width="16" height="16" onclick="getHelp('xlproAdjustments.htm')" onmouseover="showReturns('Returns: Adjustments')"><br>Align(AlignCmd, RelativeTo) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Aligns the shapes in the specified range of shapes." width="16" height="16" onclick="getHelp('xlmthAlign.htm')" onmouseover="showReturns('Returns: Void')"><br>AlternativeText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the descriptive (alternative) text string for a ShapeRange object when the object is saved to a Web page. Read/write String." width="16" height="16" onclick="getHelp('xlproAlternativeText.htm')" onmouseover="showReturns('Returns: String')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Apply() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Applies to the specified shape formatting thats been copied by using the PickUp method." width="16" height="16" onclick="getHelp('xlmthApply.htm')" onmouseover="showReturns('Returns: Void')"><br>AutoShapeType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoAutoShapeType. Use the Type property of the ConnectorFormat object to set or return the connector type." width="16" height="16" onclick="getHelp('xlproAutoShapeType.htm')" onmouseover="showReturns('Returns: MsoAutoShapeType')"><br>BlackWhiteMode [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoBlackWhiteMode. This example sets shape one on wksOne to appear in black-and-white mode. When you view the presentation in black-and-white mode, shape one will appear black regardless of what color it is in color mode." width="16" height="16" onclick="getHelp('xlproBlackWhiteMode.htm')" onmouseover="showReturns('Returns: MsoBlackWhiteMode')"><br>Callout<input type="image" src="MSGBOX02.ICO" alt="Returns: CalloutFormat. Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to Shape or ShapeRange objects that represent line callouts. Read-only." width="16" height="16" onclick="getHelp('xlproCallout.htm')" onmouseover="showReturns('Returns: CalloutFormat')"><br>CanvasCropBottom(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasCropLeft(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasCropRight(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasCropTop(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>CanvasItems<input type="image" src="MSGBOX02.ICO" alt="Returns: CanvasShapes. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: CanvasShapes')"><br>Child<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Returns msoTrue if the specified shape is a child shape or if all shapes in a shape range are child shapes of the same parent.&amp;nbsp;Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproChild.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>ConnectionSiteCount<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the number of connection sites on the specified shape. Read-only Long." width="16" height="16" onclick="getHelp('xlproConnectionSiteCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Connector<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. This example deletes all connectors on myDocument." width="16" height="16" onclick="getHelp('xlproConnector.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>ConnectorFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: ConnectorFormat. Returns a ConnectorFormat object that contains connector formatting properties. Applies to Shape or ShapeRange objects that represent connectors. Read-only." width="16" height="16" onclick="getHelp('xlproConnectorFormat.htm')" onmouseover="showReturns('Returns: ConnectorFormat')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Diagram<input type="image" src="MSGBOX02.ICO" alt="Returns: Diagram. Returns a Diagram object representing a diagram." width="16" height="16" onclick="getHelp('xlproDiagram.htm')" onmouseover="showReturns('Returns: Diagram')"><br>DiagramNode<input type="image" src="MSGBOX02.ICO" alt="Returns: DiagramNode. Returns a DiagramNode object that represents a node in a diagram." width="16" height="16" onclick="getHelp('xlproDiagramNode.htm')" onmouseover="showReturns('Returns: DiagramNode')"><br>Distribute(DistributeCmd, RelativeTo) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example defines a shape range that contains all the AutoShapes on myDocument and then horizontally distributes the shapes in this range. The leftmost shape retains its position." width="16" height="16" onclick="getHelp('xlmthDistribute.htm')" onmouseover="showReturns('Returns: Void')"><br>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: ShapeRange')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: FillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: FillFormat')"><br>Flip(FlipCmd) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example adds a triangle to myDocument, duplicates the triangle, and then flips the duplicate triangle vertically and makes it red." width="16" height="16" onclick="getHelp('xlmthFlip.htm')" onmouseover="showReturns('Returns: Void')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Group() <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Groups the shapes in the specified range. Returns the grouped shapes as a single Shape object." width="16" height="16" onclick="getHelp('xlmthGroup.htm')" onmouseover="showReturns('Returns: Shape')"><br>GroupItems<input type="image" src="MSGBOX02.ICO" alt="Returns: GroupShapes. Returns a Item method of the GroupShapes object to return a single shape from the group. Applies to Shape or ShapeRange objects that represent grouped shapes. Read-only." width="16" height="16" onclick="getHelp('xlproGroupItems.htm')" onmouseover="showReturns('Returns: GroupShapes')"><br>HasDiagram<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. &amp;nbsp;Returns whether a shape or shape range contains a diagram. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproHasDiagram.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>HasDiagramNode<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Returns whether a diagram node exists in a given shape or shape range. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproHasDiagramNode.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Single')"><br>HorizontalFlip<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the specified shape is flipped around the horizontal axis. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproHorizontalFlip.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>ID<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the type for the specified object. Read-only Long." width="16" height="16" onclick="getHelp('xlproID.htm')" onmouseover="showReturns('Returns: Int32')"><br>IncrementLeft(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the specified shape horizontally by the specified number of points." width="16" height="16" onclick="getHelp('xlmthIncrementLeft.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementRotation(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the rotation of the specified shape around the z-axis by the specified number of degrees. Use the Rotation property to set the absolute rotation of the shape." width="16" height="16" onclick="getHelp('xlmthIncrementRotation.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementTop(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the specified shape vertically by the specified number of points." width="16" height="16" onclick="getHelp('xlmthIncrementTop.htm')" onmouseover="showReturns('Returns: Void')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Shape')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Single')"><br>Line<input type="image" src="MSGBOX02.ICO" alt="Returns: LineFormat. Returns a LineFormat object that contains line formatting properties for the specified shape. (For a line, the LineFormat object represents the line itself; for a shape with a border, the LineFormat object represents the border.) Read-only." width="16" height="16" onclick="getHelp('xlproLine.htm')" onmouseover="showReturns('Returns: LineFormat')"><br>LockAspectRatio [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the specified shape retains its original proportions when you resize it. False if you can change the height and width of the shape independently of one another when you resize it. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproLockAspectRatio.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Nodes<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeNodes. Nodes property as it applies to the Diagram object." width="16" height="16" onclick="getHelp('xlproNodes.htm')" onmouseover="showReturns('Returns: ShapeNodes')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>ParentGroup<input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes." width="16" height="16" onclick="getHelp('xlproParentGroup.htm')" onmouseover="showReturns('Returns: Shape')"><br>PickUp() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape." width="16" height="16" onclick="getHelp('xlmthPickUp.htm')" onmouseover="showReturns('Returns: Void')"><br>PictureFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: PictureFormat. Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to Shape or ShapeRange objects that represent pictures or OLE objects. Read-only." width="16" height="16" onclick="getHelp('xlproPictureFormat.htm')" onmouseover="showReturns('Returns: PictureFormat')"><br>Regroup() <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Regroups the group that the specified shape range belonged to previously. Returns the regrouped shapes as a single Shape object." width="16" height="16" onclick="getHelp('xlmthRegroup.htm')" onmouseover="showReturns('Returns: Shape')"><br>RerouteConnections() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Reroutes connectors so that they take the shortest possible path between the shapes they connect. To do this, the RerouteConnections method may detach the ends of a connector and reattach them to different connecting sites on the connected shapes." width="16" height="16" onclick="getHelp('xlmthRerouteConnections.htm')" onmouseover="showReturns('Returns: Void')"><br>Rotation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Chart object: Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts. Read/write Variant." width="16" height="16" onclick="getHelp('xlproRotation.htm')" onmouseover="showReturns('Returns: Single')"><br>ScaleHeight(Factor, RelativeToOriginalSize, [Scale]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Scales the height of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current height." width="16" height="16" onclick="getHelp('xlmthScaleHeight.htm')" onmouseover="showReturns('Returns: Void')"><br>ScaleWidth(Factor, RelativeToOriginalSize, [Scale]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Scales the width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current width." width="16" height="16" onclick="getHelp('xlmthScaleWidth.htm')" onmouseover="showReturns('Returns: Void')"><br>Select([Replace]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Void')"><br>SetShapesDefaultProperties() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Makes the formatting of the specified shape the default formatting for the shape." width="16" height="16" onclick="getHelp('xlmthSetShapesDefaultProperties.htm')" onmouseover="showReturns('Returns: Void')"><br>Shadow<input type="image" src="MSGBOX02.ICO" alt="Returns: ShadowFormat. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: ShadowFormat')"><br>TextEffect<input type="image" src="MSGBOX02.ICO" alt="Returns: TextEffectFormat. Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape or ShapeRange objects that represent WordArt. Read-only." width="16" height="16" onclick="getHelp('xlproTextEffect.htm')" onmouseover="showReturns('Returns: TextEffectFormat')"><br>TextFrame<input type="image" src="MSGBOX02.ICO" alt="Returns: TextFrame. Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only." width="16" height="16" onclick="getHelp('xlproTextFrame.htm')" onmouseover="showReturns('Returns: TextFrame')"><br>ThreeD<input type="image" src="MSGBOX02.ICO" alt="Returns: ThreeDFormat. Returns a ThreeDFormat object that contains 3-D&amp;nbsp;&amp;nbsp;effect formatting properties for the specified shape. Read-only." width="16" height="16" onclick="getHelp('xlproThreeD.htm')" onmouseover="showReturns('Returns: ThreeDFormat')"><br>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Single')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoShapeType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoShapeType')"><br>Ungroup() <input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. This example ungroups any grouped shapes and disassembles any pictures or OLE objects on myDocument." width="16" height="16" onclick="getHelp('xlmthUngroup.htm')" onmouseover="showReturns('Returns: ShapeRange')"><br>VerticalFlip<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the specified shape is flipped around the vertical axis. Read-only MsoTriState." width="16" height="16" onclick="getHelp('xlproVerticalFlip.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Vertices<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the coordinates of the specified freeform drawing's vertices (and control points for Bzier curves) as a series of AddPolyLine method. Read-only Variant." width="16" height="16" onclick="getHelp('xlproVertices.htm')" onmouseover="showReturns('Returns: Object')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Single')"><br>ZOrder(ZOrderCmd) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the specified shape in front of or behind other shapes in the collection (that is, changes the shape's position in the z-order)." width="16" height="16" onclick="getHelp('xlmthZOrder.htm')" onmouseover="showReturns('Returns: Void')"><br>ZOrderPosition<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>Shapes (1997) <img src="MSGBOX02.ICO" alt="A collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture." width="16" height="16" onclick="getHelp('xlobjShapes.htm');showMozHelp('A collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.');"></h2>AddCallout(Type, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a borderless line callout. Returns a Shape object that represents the new callout." width="16" height="16" onclick="getHelp('xlmthAddCallout.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddCanvas(Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddConnector(Type, BeginX, BeginY, EndX, EndY) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a connector. Returns a EndConnect methods to attach the beginning and end of a connector to other shapes in the document." width="16" height="16" onclick="getHelp('xlmthAddConnector.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddCurve(SafeArrayOfPoints) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. As it applies to the Shapes object, returns a Shape object that represents a Bzier curve in a worksheet. As it applies to the CanvasShapes object, returns a Shape object that represents a Bzier curve in a drawing canvas." width="16" height="16" onclick="getHelp('xlmthAddCurve.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddDiagram(Type, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a diagram. Returns a Shape object that represents the new diagram." width="16" height="16" onclick="getHelp('xlmthAddDiagram.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddFormControl(Type, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a Microsoft Excel control. Returns a Shape object that represents the new control." width="16" height="16" onclick="getHelp('xlmthAddFormControl.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddLabel(Orientation, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a label. Returns a Shape object that represents the new label." width="16" height="16" onclick="getHelp('xlmthAddLabel.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddLine(BeginX, BeginY, EndX, EndY) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. As it applies to the Shapes object, returns a Shape object that represents the new line in a worksheet. As it applies to the CanvasShapes object, returns a Shape object that represents the new line in a drawing canvas." width="16" height="16" onclick="getHelp('xlmthAddLine.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddOLEObject([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddPicture(Filename, LinkToFile, SaveWithDocument, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a picture from an existing file. Returns a Shape object that represents the new picture." width="16" height="16" onclick="getHelp('xlmthAddPicture.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddPolyline(SafeArrayOfPoints) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates an open polyline or a closed polygon drawing. Returns a Shape object that represents the new polyline or polygon." width="16" height="16" onclick="getHelp('xlmthAddPolyline.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddShape(Type, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. As it applies to the Shapes object, returns a Shape object that represents the new AutoShape in a worksheet. As it applies to the CanvasShapes object, returns a Shape object that represents the new AutoShape in a drawing canvas." width="16" height="16" onclick="getHelp('xlmthAddShape.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddTextbox(Orientation, Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. This example adds a text box that contains the text Test Box to myDocument." width="16" height="16" onclick="getHelp('xlmthAddTextbox.htm')" onmouseover="showReturns('Returns: Shape')"><br>AddTextEffect(PresetTextEffect, Text, FontName, FontSize, FontBold, FontItalic, Left, Top) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. Creates a WordArt object. Returns a Shape object that represents the new WordArt object." width="16" height="16" onclick="getHelp('xlmthAddTextEffect.htm')" onmouseover="showReturns('Returns: Shape')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>BuildFreeform(EditingType, X1, Y1) <input type="image" src="MSGBOX02.ICO" alt="Returns: FreeformBuilder. This example adds a freeform with five vertices to myDocument." width="16" height="16" onclick="getHelp('xlmthBuildFreeform.htm')" onmouseover="showReturns('Returns: FreeformBuilder')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Shape. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Shape')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: ShapeRange')"><br>SelectAll() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects all the shapes in the specified CanvasShapes, DiagramNodeChildren, DiagramNodes, or Shapes collection." width="16" height="16" onclick="getHelp('xlmthSelectAll.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>TextEffectFormat (1997) <img src="MSGBOX02.ICO" alt="Contains properties and methods that apply to WordArt objects." width="16" height="16" onclick="getHelp('xlobjTextEffectFormat.htm');showMozHelp('Contains properties and methods that apply to WordArt objects.');"></h2>Alignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTextEffectAlignment. " width="16" height="16" onclick="getHelp('xlproAlignment.htm')" onmouseover="showReturns('Returns: MsoTextEffectAlignment')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>FontBold [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if the font in the specified WordArt is bold. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproFontBold.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>FontItalic [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Returns msoTrue if the font in the specified WordArt is italic. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproFontItalic.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>FontName [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the font in the specified WordArt. Read/write String." width="16" height="16" onclick="getHelp('xlproFontName.htm')" onmouseover="showReturns('Returns: String')"><br>FontSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the font size for the specified WordArt, in points. Read/write Single." width="16" height="16" onclick="getHelp('xlproFontSize.htm')" onmouseover="showReturns('Returns: Single')"><br>KernedPairs [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if character pairs in the specified WordArt are kerned. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproKernedPairs.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>NormalizedHeight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if all characters (both uppercase and lowercase) in the specified WordArt are the same height. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproNormalizedHeight.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PresetShape [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetTextEffectShape. Setting the PresetTextEffect property automatically sets the PresetShape property." width="16" height="16" onclick="getHelp('xlproPresetShape.htm')" onmouseover="showReturns('Returns: MsoPresetTextEffectShape')"><br>PresetTextEffect [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetTextEffect. Setting the PresetTextEffect property automatically sets many other formatting properties of the specified shape." width="16" height="16" onclick="getHelp('xlproPresetTextEffect.htm')" onmouseover="showReturns('Returns: MsoPresetTextEffect')"><br>RotatedChars [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. True if characters in the specified WordArt are rotated 90 degrees relative to the WordArt's bounding shape. False if characters in the specified WordArt retain their original orientation relative to the bounding shape. Read/write MsoTriState." width="16" height="16" onclick="getHelp('xlproRotatedChars.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>Text [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects." width="16" height="16" onclick="getHelp('xlproText.htm')" onmouseover="showReturns('Returns: String')"><br>ToggleVerticalText() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Switches the text flow in the specified WordArt from horizontal to vertical, or vice versa." width="16" height="16" onclick="getHelp('xlmthToggleVerticalText.htm')" onmouseover="showReturns('Returns: Void')"><br>Tracking [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the ratio of the horizontal space allotted to each character in the specified WordArt to the width of the character. Can be a value from 0 (zero) through 5. (Large values for this property specify ample space between characters; values less than 1 can produce character overlap.) Read/write Single." width="16" height="16" onclick="getHelp('xlproTracking.htm')" onmouseover="showReturns('Returns: Single')"><br><h2>TextFrame (1997) <img src="MSGBOX02.ICO" alt="Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame." width="16" height="16" onclick="getHelp('xlobjTextFrame.htm');showMozHelp('Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoMargins [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel automatically calculates text frame margins. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoMargins.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AutoSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the size of the specified object is changed automatically to fit text within its boundaries. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoSize.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Characters([Start], [Length]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within a shapes text frame. You can use the Characters object to add and format characters within the text frame." width="16" height="16" onclick="getHelp('xlmthCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlHAlign. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproHorizontalAlignment.htm')" onmouseover="showReturns('Returns: XlHAlign')"><br>MarginBottom [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the distance (in points) between the bottom of the text frame and the bottom of the inscribed rectangle of the shape that contains the text. Read/write Single." width="16" height="16" onclick="getHelp('xlproMarginBottom.htm')" onmouseover="showReturns('Returns: Single')"><br>MarginLeft [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the distance (in points) between the left edge of the text frame and the left edge of the inscribed rectangle of the shape that contains the text. Read/write Single." width="16" height="16" onclick="getHelp('xlproMarginLeft.htm')" onmouseover="showReturns('Returns: Single')"><br>MarginRight [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the distance (in points) between the right edge of the text frame and the right edge of the inscribed rectangle of the shape that contains the text. Read/write Single." width="16" height="16" onclick="getHelp('xlproMarginRight.htm')" onmouseover="showReturns('Returns: Single')"><br>MarginTop [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the distance (in points) between the top of the text frame and the top of the inscribed rectangle of the shape that contains the text. Read/write Single." width="16" height="16" onclick="getHelp('xlproMarginTop.htm')" onmouseover="showReturns('Returns: Single')"><br>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTextOrientation. For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report." width="16" height="16" onclick="getHelp('xlproOrientation.htm')" onmouseover="showReturns('Returns: MsoTextOrientation')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>ReadingOrder [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long." width="16" height="16" onclick="getHelp('xlproReadingOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlVAlign. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproVerticalAlignment.htm')" onmouseover="showReturns('Returns: XlVAlign')"><br><h2>ThreeDFormat (1997) <img src="MSGBOX02.ICO" alt="Represents three-dimensional formatting of a shape." width="16" height="16" onclick="getHelp('xlobjThreeDFormat.htm');showMozHelp('Represents three-dimensional formatting of a shape.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: Int32')"><br>Depth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. For the ThreeDFormat object, returns or sets the depth of the shape's extrusion. Can be a value from &amp;nbsp;&amp;nbsp;600 through 9600 (positive values produce an extrusion whose front face is the original shape; negative values produce an extrusion whose back face is the original shape). Read/write Single." width="16" height="16" onclick="getHelp('xlproDepth.htm')" onmouseover="showReturns('Returns: Single')"><br>ExtrusionColor<input type="image" src="MSGBOX02.ICO" alt="Returns: ColorFormat. Returns a ColorFormat object that represents the color of the shape's extrusion. Read-only." width="16" height="16" onclick="getHelp('xlproExtrusionColor.htm')" onmouseover="showReturns('Returns: ColorFormat')"><br>ExtrusionColorType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoExtrusionColorType. If shape one on myDocument has an automatic extrusion color, this example gives the extrusion a custom yellow color." width="16" height="16" onclick="getHelp('xlproExtrusionColorType.htm')" onmouseover="showReturns('Returns: MsoExtrusionColorType')"><br>IncrementRotationX(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the rotation of the specified shape around the x-axis by the specified number of degrees. Use the RotationX property to set the absolute rotation of the shape around the x-axis." width="16" height="16" onclick="getHelp('xlmthIncrementRotationX.htm')" onmouseover="showReturns('Returns: Void')"><br>IncrementRotationY(Increment) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Changes the rotation of the specified shape around the y-axis by the specified number of degrees. Use the RotationY property to set the absolute rotation of the shape around the y-axis." width="16" height="16" onclick="getHelp('xlmthIncrementRotationY.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Perspective [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Perspective property as it applies to the ThreeDFormat object." width="16" height="16" onclick="getHelp('xlproPerspective.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br>PresetExtrusionDirection<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetExtrusionDirection. This property is read-only. To set the value of this property, use the SetExtrusionDirection method." width="16" height="16" onclick="getHelp('xlproPresetExtrusionDirection.htm')" onmouseover="showReturns('Returns: MsoPresetExtrusionDirection')"><br>PresetLightingDirection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetLightingDirection. This example specifies that the extrusion for shape one on myDocument extend toward the top of the shape and that the lighting for the extrusion come from the left." width="16" height="16" onclick="getHelp('xlproPresetLightingDirection.htm')" onmouseover="showReturns('Returns: MsoPresetLightingDirection')"><br>PresetLightingSoftness [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetLightingSoftness. This example specifies that the extrusion for shape one on myDocument be lit brightly from the left." width="16" height="16" onclick="getHelp('xlproPresetLightingSoftness.htm')" onmouseover="showReturns('Returns: MsoPresetLightingSoftness')"><br>PresetMaterial [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetMaterial. This example specifies that the extrusion surface for shape one in myDocument be wire frame." width="16" height="16" onclick="getHelp('xlproPresetMaterial.htm')" onmouseover="showReturns('Returns: MsoPresetMaterial')"><br>PresetThreeDFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetThreeDFormat. This property is read-only. To set the preset extrusion format, use the SetThreeDFormat method." width="16" height="16" onclick="getHelp('xlproPresetThreeDFormat.htm')" onmouseover="showReturns('Returns: MsoPresetThreeDFormat')"><br>ResetRotation() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Resets the extrusion rotation around the x-axis and the y-axis to 0 (zero) so that the front of the extrusion faces forward. This method doesnt reset the rotation around the z-axis." width="16" height="16" onclick="getHelp('xlmthResetRotation.htm')" onmouseover="showReturns('Returns: Void')"><br>RotationX [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Single')"><br>RotationY [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns or sets the rotation of the extruded shape around the y-axis in degrees. Can be a value from &amp;nbsp;&amp;nbsp;90 through 90. A positive value indicates rotation to the left; a negative value indicates rotation to the right. Read/write Single." width="16" height="16" onclick="getHelp('xlproRotationY.htm')" onmouseover="showReturns('Returns: Single')"><br>SetExtrusionDirection(PresetExtrusionDirection) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the direction that the extrusion's sweep path takes away from the extruded shape." width="16" height="16" onclick="getHelp('xlmthSetExtrusionDirection.htm')" onmouseover="showReturns('Returns: Void')"><br>SetThreeDFormat(PresetThreeDFormat) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the preset extrusion format. Each preset extrusion format contains a set of preset values for the various properties of the extrusion." width="16" height="16" onclick="getHelp('xlmthSetThreeDFormat.htm')" onmouseover="showReturns('Returns: Void')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br></body> </html>