ÿþ<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">348600.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>x Appendix B</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 Hidden/Obsolete Objects</H1> <h2>Arc (1995) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>AddIndent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. To set text alignment to equal distribution, you can set the HorizontalAlignment property to xlHAlignDistributed when the value of the Orientation property is xlHorizontal." width="16" height="16" onclick="getHelp('xlproAddIndent.htm')" onmouseover="showReturns('Returns: Boolean')"><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>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><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>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>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>BringToFront() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Brings the object to the front of the z-order." width="16" height="16" onclick="getHelp('xlmthBringToFront.htm')" onmouseover="showReturns('Returns: Object')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption 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('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.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>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.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>Cut() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Object')"><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>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: Object')"><br>Enabled [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnabled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Formula [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Formula property as it applies to the PivotField, PivotFormula, PivotItem, and Series objects." width="16" height="16" onclick="getHelp('xlproFormula.htm')" onmouseover="showReturns('Returns: String')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><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>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><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>LockedText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the text in the specified object will be locked to prevent changes when the workbook is protected. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproLockedText.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>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>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: 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>Placement [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>PrintObject [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object will be printed when the document is printed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPrintObject.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Select([Replace]) <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>SendToBack() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Sends the object to the back of the z-order." width="16" height="16" onclick="getHelp('xlmthSendToBack.htm')" onmouseover="showReturns('Returns: Object')"><br>ShapeRange<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Returns a ShapeRange object that represents the specified object or objects. Read-only." width="16" height="16" onclick="getHelp('xlproShapeRange.htm')" onmouseover="showReturns('Returns: ShapeRange')"><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>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><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>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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: Boolean')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><br>ZOrder<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the z-order position of the object. Read-only Long." width="16" height="16" onclick="getHelp('xlproZOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>Arcs (1995) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>Add(X1, Y1, X2, Y2) <input type="image" src="MSGBOX02.ICO" alt="Returns: Arc. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Arc')"><br>AddIndent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. To set text alignment to equal distribution, you can set the HorizontalAlignment property to xlHAlignDistributed when the value of the Orientation property is xlHorizontal." width="16" height="16" onclick="getHelp('xlproAddIndent.htm')" onmouseover="showReturns('Returns: Boolean')"><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>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><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>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>BringToFront() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Brings the object to the front of the z-order." width="16" height="16" onclick="getHelp('xlmthBringToFront.htm')" onmouseover="showReturns('Returns: Object')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption 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('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.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>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.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>Cut() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Object')"><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>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: Object')"><br>Enabled [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnabled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Formula [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Formula property as it applies to the PivotField, PivotFormula, PivotItem, and Series objects." width="16" height="16" onclick="getHelp('xlproFormula.htm')" onmouseover="showReturns('Returns: String')"><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: GroupObject. 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: GroupObject')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><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>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Object')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><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>LockedText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the text in the specified object will be locked to prevent changes when the workbook is protected. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproLockedText.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: 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>Placement [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>PrintObject [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object will be printed when the document is printed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPrintObject.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Select([Replace]) <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>SendToBack() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Sends the object to the back of the z-order." width="16" height="16" onclick="getHelp('xlmthSendToBack.htm')" onmouseover="showReturns('Returns: Object')"><br>ShapeRange<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Returns a ShapeRange object that represents the specified object or objects. Read-only." width="16" height="16" onclick="getHelp('xlproShapeRange.htm')" onmouseover="showReturns('Returns: ShapeRange')"><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>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><br>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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: Boolean')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><br>ZOrder<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the z-order position of the object. Read-only Long." width="16" height="16" onclick="getHelp('xlproZOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>Button (1995) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>Accelerator [= setting]<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>AddIndent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. To set text alignment to equal distribution, you can set the HorizontalAlignment property to xlHAlignDistributed when the value of the Orientation property is xlHorizontal." width="16" height="16" onclick="getHelp('xlproAddIndent.htm')" onmouseover="showReturns('Returns: Boolean')"><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>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><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>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>BringToFront() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Brings the object to the front of the z-order." width="16" height="16" onclick="getHelp('xlmthBringToFront.htm')" onmouseover="showReturns('Returns: Object')"><br>CancelButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption 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('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.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>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.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>Cut() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Object')"><br>DefaultButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><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>DismissButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: Object')"><br>Enabled [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnabled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Formula [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Formula property as it applies to the PivotField, PivotFormula, PivotItem, and Series objects." width="16" height="16" onclick="getHelp('xlproFormula.htm')" onmouseover="showReturns('Returns: String')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>HelpButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><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>LockedText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the text in the specified object will be locked to prevent changes when the workbook is protected. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproLockedText.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>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>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: 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>PhoneticAccelerator [= setting]<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>Placement [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>PrintObject [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object will be printed when the document is printed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPrintObject.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Select([Replace]) <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>SendToBack() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Sends the object to the back of the z-order." width="16" height="16" onclick="getHelp('xlmthSendToBack.htm')" onmouseover="showReturns('Returns: Object')"><br>ShapeRange<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Returns a ShapeRange object that represents the specified object or objects. Read-only." width="16" height="16" onclick="getHelp('xlproShapeRange.htm')" onmouseover="showReturns('Returns: ShapeRange')"><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>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><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>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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: Boolean')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><br>ZOrder<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the z-order position of the object. Read-only Long." width="16" height="16" onclick="getHelp('xlproZOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>Buttons (1995) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>Accelerator [= setting]<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>Add(Left, Top, Width, Height) <input type="image" src="MSGBOX02.ICO" alt="Returns: Button. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Button')"><br>AddIndent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. To set text alignment to equal distribution, you can set the HorizontalAlignment property to xlHAlignDistributed when the value of the Orientation property is xlHorizontal." width="16" height="16" onclick="getHelp('xlproAddIndent.htm')" onmouseover="showReturns('Returns: Boolean')"><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>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><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>BringToFront() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Brings the object to the front of the z-order." width="16" height="16" onclick="getHelp('xlmthBringToFront.htm')" onmouseover="showReturns('Returns: Object')"><br>CancelButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption 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('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.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>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.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>Cut() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Object')"><br>DefaultButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><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>DismissButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: Object')"><br>Enabled [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnabled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Formula [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Formula property as it applies to the PivotField, PivotFormula, PivotItem, and Series objects." width="16" height="16" onclick="getHelp('xlproFormula.htm')" onmouseover="showReturns('Returns: String')"><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: GroupObject. 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: GroupObject')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>HelpButton [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Object')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><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>LockedText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the text in the specified object will be locked to prevent changes when the workbook is protected. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproLockedText.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: 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>PhoneticAccelerator [= setting]<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>Placement [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>PrintObject [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object will be printed when the document is printed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPrintObject.htm')" onmouseover="showReturns('Returns: Boolean')"><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>Select([Replace]) <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>SendToBack() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Sends the object to the back of the z-order." width="16" height="16" onclick="getHelp('xlmthSendToBack.htm')" onmouseover="showReturns('Returns: Object')"><br>ShapeRange<input type="image" src="MSGBOX02.ICO" alt="Returns: ShapeRange. Returns a ShapeRange object that represents the specified object or objects. Read-only." width="16" height="16" onclick="getHelp('xlproShapeRange.htm')" onmouseover="showReturns('Returns: ShapeRange')"><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>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><br>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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: Boolean')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. 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: Double')"><br>ZOrder<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the z-order position of the object. Read-only Long." width="16" height="16" onclick="getHelp('xlproZOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>CheckBox (1995) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>Accelerator [= setting]<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>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>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>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>BringToFront() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Brings the object to the front of the z-order." width="16" height="16" onclick="getHelp('xlmthBringToFront.htm')" onmouseover="showReturns('Returns: Object')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption 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('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. To check headers, footers, and objects on a worksheet, use this method on a Worksheet object." width="16" height="16" onclick="getHelp('xlmthCheckSpelling.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>CopyPicture([Appearance], [Format]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. If you copy a range, it must be made up of adjacent cells." width="16" height="16" onclick="getHelp('xlmthCopyPicture.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>Cut() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Cuts the object to the Clipboard or pastes it into a specified destination." width="16" height="16" onclick="getHelp('xlmthCut.htm')" onmouseover="showReturns('Returns: Object')"><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>Display3DShading [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Duplicate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Duplicates the object and returns a reference to the new copy." width="16" height="16" onclick="getHelp('xlmthDuplicate.htm')" onmouseover="showReturns('Returns: Object')"><br>Enabled [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnabled.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><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>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. If the window is maximized, Applicati