ÿþ<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">348100.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>Chapter 07</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 Control Objects</H1> <h2>AppEvents (1997) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>NewWorkbook(Wb) <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>SheetActivate(Sh) <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>SheetBeforeDoubleClick(Sh, Target, Cancel) <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>SheetBeforeRightClick(Sh, Target, Cancel) <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>SheetCalculate(Sh) <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>SheetChange(Sh, Target) <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>SheetDeactivate(Sh) <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>SheetFollowHyperlink(Sh, Target) <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>SheetPivotTableUpdate(Sh, Target) <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>SheetSelectionChange(Sh, Target) <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>WindowActivate(Wb, Wn) <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>WindowDeactivate(Wb, Wn) <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>WindowResize(Wb, Wn) <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>WorkbookActivate(Wb) <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>WorkbookAddinInstall(Wb) <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>WorkbookAddinUninstall(Wb) <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>WorkbookAfterXmlExport(Wb, Map, Url, Result) <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>WorkbookAfterXmlImport(Wb, Map, IsRefresh, Result) <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>WorkbookBeforeClose(Wb, Cancel) <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>WorkbookBeforePrint(Wb, Cancel) <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>WorkbookBeforeSave(Wb, SaveAsUI, Cancel) <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>WorkbookBeforeXmlExport(Wb, Map, Url, Cancel) <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>WorkbookBeforeXmlImport(Wb, Map, Url, IsRefresh, Cancel) <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>WorkbookDeactivate(Wb) <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>WorkbookNewSheet(Wb, Sh) <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>WorkbookOpen(Wb) <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>WorkbookPivotTableCloseConnection(Wb, Target) <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>WorkbookPivotTableOpenConnection(Wb, Target) <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>WorkbookSync(Wb, SyncEventType) <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><h2>Application (1995) <img src="MSGBOX02.ICO" alt="Represents the entire Microsoft Excel application." width="16" height="16" onclick="getHelp('xlobjApplication.htm');showMozHelp('Represents the entire Microsoft Excel application.');"></h2>ActivateMicrosoftApp(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application." width="16" height="16" onclick="getHelp('xlmthActivateMicrosoftApp.htm')" onmouseover="showReturns('Returns: Void')"><br>ActiveCell<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window isn't displaying a worksheet, this property fails. Read-only." width="16" height="16" onclick="getHelp('xlproActiveCell.htm')" onmouseover="showReturns('Returns: Range')"><br>ActiveChart<input type="image" src="MSGBOX02.ICO" alt="Returns: Chart. Returns a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns Nothing. Read-only." width="16" height="16" onclick="getHelp('xlproActiveChart.htm')" onmouseover="showReturns('Returns: Chart')"><br>ActiveDialog<input type="image" src="MSGBOX02.ICO" alt="Returns: DialogSheet. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: DialogSheet')"><br>ActiveMenuBar<input type="image" src="MSGBOX02.ICO" alt="Returns: MenuBar. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: MenuBar')"><br>ActivePrinter [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the active printer. Read/write String." width="16" height="16" onclick="getHelp('xlproActivePrinter.htm')" onmouseover="showReturns('Returns: String')"><br>ActiveSheet<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only." width="16" height="16" onclick="getHelp('xlproActiveSheet.htm')" onmouseover="showReturns('Returns: Object')"><br>ActiveWindow<input type="image" src="MSGBOX02.ICO" alt="Returns: Window. Returns a Window object that represents the active window (the window on top). Read-only. Returns Nothing if there are no windows open." width="16" height="16" onclick="getHelp('xlproActiveWindow.htm')" onmouseover="showReturns('Returns: Window')"><br>ActiveWorkbook<input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. Returns a Workbook object that represents the workbook in the active window (the window on top). Read-only. Returns Nothing if there are no windows open or if either the Info window or the Clipboard window is the active window." width="16" height="16" onclick="getHelp('xlproActiveWorkbook.htm')" onmouseover="showReturns('Returns: Workbook')"><br>AddChartAutoFormat(Chart, Name, [Description]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Adds a custom chart autoformat to the list of available chart autoformats." width="16" height="16" onclick="getHelp('xlmthAddChartAutoFormat.htm')" onmouseover="showReturns('Returns: Void')"><br>AddCustomList(ListArray, [ByRow]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Adds a custom list for custom autofill and/or custom sort." width="16" height="16" onclick="getHelp('xlmthAddCustomList.htm')" onmouseover="showReturns('Returns: Void')"><br>AddIns<input type="image" src="MSGBOX02.ICO" alt="Returns: AddIns. Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Tools menu). Read-only." width="16" height="16" onclick="getHelp('xlproAddIns.htm')" onmouseover="showReturns('Returns: AddIns')"><br>AlertBeforeOverwriting [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAlertBeforeOverwriting.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AltStartupPath [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the alternate startup folder. Read/write String." width="16" height="16" onclick="getHelp('xlproAltStartupPath.htm')" onmouseover="showReturns('Returns: String')"><br>AnswerWizard<input type="image" src="MSGBOX02.ICO" alt="Returns: AnswerWizard. Returns the AnswerWizard object for Microsoft Excel. Read-only." width="16" height="16" onclick="getHelp('xlproAnswerWizard.htm')" onmouseover="showReturns('Returns: AnswerWizard')"><br>AppEvents_Event_NewWorkbook<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><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>ArbitraryXMLSupportAvailable<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>AskToUpdateLinks [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel asks the user to update links when opening files with links. False if links are automatically updated with no dialog box. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAskToUpdateLinks.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Assistant<input type="image" src="MSGBOX02.ICO" alt="Returns: Assistant. Returns an Assistant object for Microsoft Excel." width="16" height="16" onclick="getHelp('xlproAssistant.htm')" onmouseover="showReturns('Returns: Assistant')"><br>AutoCorrect<input type="image" src="MSGBOX02.ICO" alt="Returns: AutoCorrect. Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes. Read-only." width="16" height="16" onclick="getHelp('xlproAutoCorrect.htm')" onmouseover="showReturns('Returns: AutoCorrect')"><br>AutoFormatAsYouTypeReplaceHyperlinks [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True (default) if Microsoft Excel automatically formats hyperlinks as you type. False if Excel does not automatically format hyperlinks as you type. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoFormatAsYouTypeReplaceHyperlinks.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AutomationSecurity [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoAutomationSecurity. Returns or sets an msoAutomationSecurityLow when the application is started. Therefore, to avoid breaking solutions that rely on the default setting, you should be careful to reset this property to msoAutomationSecurityLow after programmatically opening a file. Also, this property should be set immediately before and after opening a file programmatically to avoid malicious subversion. Read/write." width="16" height="16" onclick="getHelp('xlproAutomationSecurity.htm')" onmouseover="showReturns('Returns: MsoAutomationSecurity')"><br>AutoPercentEntry [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if entries in cells formatted as percentages arent automatically multiplied by 100 as soon as they are entered. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoPercentEntry.htm')" onmouseover="showReturns('Returns: Boolean')"><br>AutoRecover<input type="image" src="MSGBOX02.ICO" alt="Returns: AutoRecover. Returns an AutoRecover object, which backs up all file formats on a timed interval." width="16" height="16" onclick="getHelp('xlproAutoRecover.htm')" onmouseover="showReturns('Returns: AutoRecover')"><br>Build<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the Microsoft Excel build number. Read-only Long." width="16" height="16" onclick="getHelp('xlproBuild.htm')" onmouseover="showReturns('Returns: Int32')"><br>Calculate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table." width="16" height="16" onclick="getHelp('xlmthCalculate.htm')" onmouseover="showReturns('Returns: Void')"><br>CalculateBeforeSave [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if workbooks are calculated before they're saved to disk (if the Calculation property is set to xlManual). This property is preserved even if you change the Calculation property. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproCalculateBeforeSave.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CalculateFull() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Forces a full calculation of the data in all open workbooks." width="16" height="16" onclick="getHelp('xlmthCalculateFull.htm')" onmouseover="showReturns('Returns: Void')"><br>CalculateFullRebuild() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. For all open workbooks, forces a full calculation of the data and rebuilds the dependencies." width="16" height="16" onclick="getHelp('xlmthCalculateFullRebuild.htm')" onmouseover="showReturns('Returns: Void')"><br>Calculation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCalculation. For OLAP data sources, this property can only return or be set to xlNormal." width="16" height="16" onclick="getHelp('xlproCalculation.htm')" onmouseover="showReturns('Returns: XlCalculation')"><br>CalculationInterruptKey [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCalculationInterruptKey. Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations. Read/write." width="16" height="16" onclick="getHelp('xlproCalculationInterruptKey.htm')" onmouseover="showReturns('Returns: XlCalculationInterruptKey')"><br>CalculationState<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCalculationState. Returns an XlCalculationState constant that indicates the calculation state of the application, for any calculations that are being performed in Microsoft Excel. Read-only." width="16" height="16" onclick="getHelp('xlproCalculationState.htm')" onmouseover="showReturns('Returns: XlCalculationState')"><br>CalculationVersion<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. If the workbook was saved in an earlier version of Excel and if the workbook hasn't been fully recalculated, then this property returns 0." width="16" height="16" onclick="getHelp('xlproCalculationVersion.htm')" onmouseover="showReturns('Returns: Int32')"><br>Caller<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns information about how Visual Basic was called (for more information, see the Remarks section)." width="16" height="16" onclick="getHelp('xlproCaller.htm')" onmouseover="showReturns('Returns: Object')"><br>CanPlaySounds<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. This property should not be used. Sound notes have been removed from Microsoft Excel." width="16" height="16" onclick="getHelp('xlproCanPlaySounds.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CanRecordSounds<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. This property should not be used. Sound notes have been removed from Microsoft Excel." width="16" height="16" onclick="getHelp('xlproCanRecordSounds.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>CellDragAndDrop [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if dragging and dropping cells is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproCellDragAndDrop.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Cells<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Because the default property for the Range object, you can specify the row and column index immediately after the Cells keyword. For more information, see the Item property and the examples for this topic." width="16" height="16" onclick="getHelp('xlproCells.htm')" onmouseover="showReturns('Returns: Range')"><br>CentimetersToPoints(Centimeters) <input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Converts a measurement from centimeters to points (one point equals 0.035 centimeters)." width="16" height="16" onclick="getHelp('xlmthCentimetersToPoints.htm')" onmouseover="showReturns('Returns: Double')"><br>Charts<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Using this property without an object qualifier returns all chart sheets in the active workbook." width="16" height="16" onclick="getHelp('xlproCharts.htm')" onmouseover="showReturns('Returns: Sheets')"><br>CheckAbort([KeepAbort]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Stops recalculation in a Microsoft Excel application." width="16" height="16" onclick="getHelp('xlmthCheckAbort.htm')" onmouseover="showReturns('Returns: Void')"><br>CheckSpelling(Word, [CustomDictionary], [IgnoreUppercase]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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: Boolean')"><br>ClipboardFormats<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example displays a message box if the Clipboard contains a rich-text format (RTF) object. You can create an RTF object by copying text from a Word document." width="16" height="16" onclick="getHelp('xlproClipboardFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>ColorButtons [= 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>Columns<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. For information about returning a single member of a collection, see Returning an Object from a Collection." width="16" height="16" onclick="getHelp('xlproColumns.htm')" onmouseover="showReturns('Returns: Range')"><br>COMAddIns<input type="image" src="MSGBOX02.ICO" alt="Returns: COMAddIns. Returns the COMAddIns collection for Microsoft Excel, which represents the currently installed COM add-ins. Read-only." width="16" height="16" onclick="getHelp('xlproCOMAddIns.htm')" onmouseover="showReturns('Returns: COMAddIns')"><br>CommandBars<input type="image" src="MSGBOX02.ICO" alt="Returns: CommandBars. Returns a CommandBars object that represents the Microsoft Excel command bars. Read-only." width="16" height="16" onclick="getHelp('xlproCommandBars.htm')" onmouseover="showReturns('Returns: CommandBars')"><br>CommandUnderlines [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCommandUnderlines. In Microsoft Excel for Windows, reading this property always returns xlCommandUnderlinesOn, and setting this property to anything other than xlCommandUnderlinesOn is an error." width="16" height="16" onclick="getHelp('xlproCommandUnderlines.htm')" onmouseover="showReturns('Returns: XlCommandUnderlines')"><br>ConstrainNumeric [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if handwriting recognition is limited to numbers and punctuation only. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproConstrainNumeric.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ControlCharacters [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel displays control characters for right-to-left languages. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproControlCharacters.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ConvertFormula(Formula, FromReferenceStyle, [ToReferenceStyle], [ToAbsolute], [RelativeTo]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example converts a SUM formula that contains R1C1-style references to an equivalent formula that contains A1-style references, and then it displays the result." width="16" height="16" onclick="getHelp('xlmthConvertFormula.htm')" onmouseover="showReturns('Returns: Object')"><br>CopyObjectsWithCells [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if objects are cut, copied, extracted, and sorted with cells. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproCopyObjectsWithCells.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CreateObjRef(requestedType) <input type="image" src="MSGBOX02.ICO" alt="Returns: ObjRef. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ObjRef')"><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>Cursor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlMousePointer. Returns or sets the appearance of the mouse pointer in Microsoft Excel. Read/write XlMousePointer." width="16" height="16" onclick="getHelp('xlproCursor.htm')" onmouseover="showReturns('Returns: XlMousePointer')"><br>CursorMovement [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets a value that indicates whether a visual cursor or a logical cursor is used. Can be one of the following constants: xlVisualCursor or xlLogicalCursor. Read/write Long." width="16" height="16" onclick="getHelp('xlproCursorMovement.htm')" onmouseover="showReturns('Returns: Int32')"><br>CustomListCount<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the number of defined custom lists (including built-in lists). Read-only Long." width="16" height="16" onclick="getHelp('xlproCustomListCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>CutCopyMode [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCutCopyMode. Returns or sets the status of Cut or Copy mode. Can be True, False, or an XLCutCopyMode constant, as shown in the following tables. Read/write Long." width="16" height="16" onclick="getHelp('xlproCutCopyMode.htm')" onmouseover="showReturns('Returns: XlCutCopyMode')"><br>DataEntryMode [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets Data Entry mode, as shown in the following table. When in Data Entry mode, you can enter data only in the unlocked cells in the currently selected range. Read/write Long." width="16" height="16" onclick="getHelp('xlproDataEntryMode.htm')" onmouseover="showReturns('Returns: Int32')"><br>DDEAppReturnCode<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the application-specific DDE return code that was contained in the last DDE acknowledge message received by Microsoft Excel. Read-only Long." width="16" height="16" onclick="getHelp('xlproDDEAppReturnCode.htm')" onmouseover="showReturns('Returns: Int32')"><br>DDEExecute(Channel, String) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Runs a command or performs some other action or actions in another application by way of the specified DDE channel. " width="16" height="16" onclick="getHelp('xlmthDDEExecute.htm')" onmouseover="showReturns('Returns: Void')"><br>DDEInitiate(App, Topic) <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Opens a DDE channel to an application." width="16" height="16" onclick="getHelp('xlmthDDEInitiate.htm')" onmouseover="showReturns('Returns: Int32')"><br>DDEPoke(Channel, Item, Data) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sends data to an application." width="16" height="16" onclick="getHelp('xlmthDDEPoke.htm')" onmouseover="showReturns('Returns: Void')"><br>DDERequest(Channel, Item) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Requests information from the specified application. This method always returns an array; for more information, see the example." width="16" height="16" onclick="getHelp('xlmthDDERequest.htm')" onmouseover="showReturns('Returns: Object')"><br>DDETerminate(Channel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Closes a channel to another application." width="16" height="16" onclick="getHelp('xlmthDDETerminate.htm')" onmouseover="showReturns('Returns: Void')"><br>DecimalSeparator [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Sets or returns&amp;nbsp;the character used for the decimal separator as a String. Read/write." width="16" height="16" onclick="getHelp('xlproDecimalSeparator.htm')" onmouseover="showReturns('Returns: String')"><br>DefaultFilePath [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the default path that Microsoft Excel uses when it opens files. Read/write String." width="16" height="16" onclick="getHelp('xlproDefaultFilePath.htm')" onmouseover="showReturns('Returns: String')"><br>DefaultSaveFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlFileFormat. Returns or sets the default format for saving files. For a list of valid constants, see the FileFormat property. Read/write Long." width="16" height="16" onclick="getHelp('xlproDefaultSaveFormat.htm')" onmouseover="showReturns('Returns: XlFileFormat')"><br>DefaultSheetDirection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the default direction in which Microsoft Excel displays new windows and worksheets. Can be one of the following constants: xlRTL (right to left) or xlLTR (left to right). Read/write Long." width="16" height="16" onclick="getHelp('xlproDefaultSheetDirection.htm')" onmouseover="showReturns('Returns: Int32')"><br>DefaultWebOptions<input type="image" src="MSGBOX02.ICO" alt="Returns: DefaultWebOptions. Returns the DefaultWebOptions object that contains global application-level attributes used by Microsoft Excel whenever you save a document as a Web page or open a Web page. Read-only." width="16" height="16" onclick="getHelp('xlproDefaultWebOptions.htm')" onmouseover="showReturns('Returns: DefaultWebOptions')"><br>DeleteChartAutoFormat(Name) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Removes a custom chart autoformat from the list of available chart autoformats." width="16" height="16" onclick="getHelp('xlmthDeleteChartAutoFormat.htm')" onmouseover="showReturns('Returns: Void')"><br>DeleteCustomList(ListNum) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deletes a custom list." width="16" height="16" onclick="getHelp('xlmthDeleteCustomList.htm')" onmouseover="showReturns('Returns: Void')"><br>Dialogs<input type="image" src="MSGBOX02.ICO" alt="Returns: Dialogs. Returns a Dialogs collection that represents all built-in dialog boxes. Read-only." width="16" height="16" onclick="getHelp('xlproDialogs.htm')" onmouseover="showReturns('Returns: Dialogs')"><br>DialogSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Sheets')"><br>DisplayAlerts [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel displays certain alerts and messages while a macro is running. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayAlerts.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayClipboardWindow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True if the Microsoft Office Clipboard can be displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayClipboardWindow.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayCommentIndicator [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCommentDisplayMode. Returns or sets the way cells display comments and indicators. Can be one of the following XlCommentDisplayMode constants: xlNoIndicator, xlCommentIndicatorOnly, or xlCommentAndIndicator. Read/write Long." width="16" height="16" onclick="getHelp('xlproDisplayCommentIndicator.htm')" onmouseover="showReturns('Returns: XlCommentDisplayMode')"><br>DisplayDocumentActionTaskPane [= 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>DisplayExcel4Menus [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel displays version 4.0 menu bars. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayExcel4Menus.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayFormulaBar [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the formula bar is displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayFormulaBar.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayFullScreen [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel is in full-screen mode. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayFullScreen.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayFunctionToolTips [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if function ToolTips can be displayed.&amp;nbsp;Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayFunctionToolTips.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayInfoWindow [= 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>DisplayInsertOptions [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the Insert Options button should be displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayInsertOptions.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayNoteIndicator [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if cells containing notes display cell tips and contain note indicators (small dots in their upper-right corners). Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayNoteIndicator.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayPasteOptions [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the Paste Options button can be displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayPasteOptions.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayRecentFiles [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the list of recently used files is displayed on the File menu. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayRecentFiles.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayScrollBars [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if scroll bars are visible for all workbooks. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayScrollBars.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayStatusBar [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the status bar is displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayStatusBar.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayXMLSourcePane([XmlMap]) <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>DoubleClick() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Equivalent to double-clicking the active cell." width="16" height="16" onclick="getHelp('xlmthDoubleClick.htm')" onmouseover="showReturns('Returns: Void')"><br>Dummy1([Arg1], [Arg2], [Arg3], [Arg4]) <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>Dummy10([arg]) <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>Dummy101<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>Dummy11() <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>Dummy12(p1, p2) <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>Dummy13(Arg1, [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30]) <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>Dummy14() <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>Dummy2([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8]) <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>Dummy3() <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>Dummy4([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15]) <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>Dummy5([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13]) <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>Dummy6() <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>Dummy7() <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>Dummy8([Arg1]) <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>Dummy9() <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>EditDirectlyInCell [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel allows editing in cells. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEditDirectlyInCell.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableAnimations [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if animated insertion and deletion is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableAnimations.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableAutoComplete [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the AutoComplete feature is enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableAutoComplete.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableCancelKey [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlEnableCancelKey. Use this property very carefully. If you use xlDisabled, there's no way to interrupt a runaway loop or other non&amp;nbsp;&amp;nbsp;self-terminating code. Likewise, if you use xlErrorHandler but your error handler always returns using the Resume statement, there's no way to stop runaway code." width="16" height="16" onclick="getHelp('xlproEnableCancelKey.htm')" onmouseover="showReturns('Returns: XlEnableCancelKey')"><br>EnableEvents [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if events are enabled for the specified object. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableEvents.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableSound [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if sound is enabled for Microsoft Office. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableSound.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableTipWizard [= 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>Equals(obj) <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>ErrorCheckingOptions<input type="image" src="MSGBOX02.ICO" alt="Returns: ErrorCheckingOptions. Returns an ErrorCheckingOptions object, which represents the error checking options for an application.&amp;nbsp;" width="16" height="16" onclick="getHelp('xlproErrorCheckingOptions.htm')" onmouseover="showReturns('Returns: ErrorCheckingOptions')"><br>Evaluate(Name) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Converts a Microsoft Excel name to an object or a value." width="16" height="16" onclick="getHelp('xlmthEvaluate.htm')" onmouseover="showReturns('Returns: Object')"><br>Excel4IntlMacroSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproExcel4IntlMacroSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>Excel4MacroSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproExcel4MacroSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>ExecuteExcel4Macro(String) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function." width="16" height="16" onclick="getHelp('xlmthExecuteExcel4Macro.htm')" onmouseover="showReturns('Returns: Object')"><br>ExtendList [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproExtendList.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FeatureInstall [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoFeatureInstall. You can use the msoFeatureInstallOnDemandWithUI constant to prevent users from thinking that the application isn't responding while a feature is being installed. Use the msoFeatureInstallNone constant if you want the developer to be the only one who can install features." width="16" height="16" onclick="getHelp('xlproFeatureInstall.htm')" onmouseover="showReturns('Returns: MsoFeatureInstall')"><br>FileConverters<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns information about installed file converters. Returns Null if there are no converters installed. Read-only Variant." width="16" height="16" onclick="getHelp('xlproFileConverters.htm')" onmouseover="showReturns('Returns: Object')"><br>FileDialog<input type="image" src="MSGBOX02.ICO" alt="Returns: FileDialog. Returns a FileDialog object representing an instance of the file dialog." width="16" height="16" onclick="getHelp('xlproFileDialog.htm')" onmouseover="showReturns('Returns: FileDialog')"><br>FileFind<input type="image" src="MSGBOX02.ICO" alt="Returns: IFind. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproFileFind.htm')" onmouseover="showReturns('Returns: IFind')"><br>FileSearch<input type="image" src="MSGBOX02.ICO" alt="Returns: FileSearch. Returns a FileSearch object for use with file searches. This property is available only in Microsoft Windows." width="16" height="16" onclick="getHelp('xlproFileSearch.htm')" onmouseover="showReturns('Returns: FileSearch')"><br>FindFile() <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Displays the Open dialog box." width="16" height="16" onclick="getHelp('xlmthFindFile.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FindFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: CellFormat. Sets or returns the search criteria for the type of cell formats to find." width="16" height="16" onclick="getHelp('xlproFindFormat.htm')" onmouseover="showReturns('Returns: CellFormat')"><br>FixedDecimal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. All data entered after this property is set to True will be formatted with the number of fixed decimal places set by the FixedDecimalPlaces property. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproFixedDecimal.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FixedDecimalPlaces [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True. Read/write Long." width="16" height="16" onclick="getHelp('xlproFixedDecimalPlaces.htm')" onmouseover="showReturns('Returns: Int32')"><br>GenerateGetPivotData [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True when Microsoft Excel can get PivotTable report data. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproGenerateGetPivotData.htm')" onmouseover="showReturns('Returns: Boolean')"><br>GetCustomListContents(ListNum) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns a custom list (an array of strings)." width="16" height="16" onclick="getHelp('xlmthGetCustomListContents.htm')" onmouseover="showReturns('Returns: Object')"><br>GetCustomListNum(ListArray) <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the custom list number for an array of strings. You can use this method to match both built-in lists and custom-defined lists." width="16" height="16" onclick="getHelp('xlmthGetCustomListNum.htm')" onmouseover="showReturns('Returns: Int32')"><br>GetHashCode() <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>GetLifetimeService() <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>GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText], [MultiSelect]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays the standard Open dialog box and gets a file name from the user without actually opening any files." width="16" height="16" onclick="getHelp('xlmthGetOpenFilename.htm')" onmouseover="showReturns('Returns: Object')"><br>GetPhonetic([Text]) <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the Japanese phonetic text of the specified text string. This method is available to you only if you have selected or installed Japanese language support for Microsoft Office." width="16" height="16" onclick="getHelp('xlmthGetPhonetic.htm')" onmouseover="showReturns('Returns: String')"><br>GetSaveAsFilename([InitialFilename], [FileFilter], [FilterIndex], [Title], [ButtonText]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays the standard Save As dialog box and gets a file name from the user without actually saving any files." width="16" height="16" onclick="getHelp('xlmthGetSaveAsFilename.htm')" onmouseover="showReturns('Returns: Object')"><br>GetType() <input type="image" src="MSGBOX02.ICO" alt="Returns: Type. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Type')"><br>Goto([Reference], [Scroll]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects any range or Visual Basic procedure in any workbook, and activates that workbook if its not already active." width="16" height="16" onclick="getHelp('xlmthGoto.htm')" onmouseover="showReturns('Returns: Void')"><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>Help([HelpFile], [HelpContextID]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Displays a Help topic." width="16" height="16" onclick="getHelp('xlmthHelp.htm')" onmouseover="showReturns('Returns: Void')"><br>Hinstance<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the instance handle of the instance that is calling Microsoft Excel. Read-only Long." width="16" height="16" onclick="getHelp('xlproHinstance.htm')" onmouseover="showReturns('Returns: Int32')"><br>Hwnd<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns a Long indicating the top-level window handle of the Microsoft Excel window. Read-only." width="16" height="16" onclick="getHelp('xlproHwnd.htm')" onmouseover="showReturns('Returns: Int32')"><br>IgnoreRemoteRequests [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if remote DDE requests are ignored. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIgnoreRemoteRequests.htm')" onmouseover="showReturns('Returns: Boolean')"><br>InchesToPoints(Inches) <input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Converts a measurement from inches to points." width="16" height="16" onclick="getHelp('xlmthInchesToPoints.htm')" onmouseover="showReturns('Returns: Double')"><br>InitializeLifetimeService() <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>InputBox(Prompt, [Title], [Default], [Left], [Top], [HelpFile], [HelpContextID], [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Displays a dialog box for user input. Returns the information entered in the dialog box." width="16" height="16" onclick="getHelp('xlmthInputBox.htm')" onmouseover="showReturns('Returns: Object')"><br>Interactive [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel is in interactive mode; this property is usually True. If you set the this property to False, Microsoft Excel will block all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code). Blocking user input will prevent the user from interfering with the macro as it moves or activates Microsoft Excel objects. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproInteractive.htm')" onmouseover="showReturns('Returns: Boolean')"><br>International<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns information about the current country/region and international settings. Read-only Variant." width="16" height="16" onclick="getHelp('xlproInternational.htm')" onmouseover="showReturns('Returns: Object')"><br>Intersect(Arg1, Arg2, [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the rectangular intersection of two or more ranges." width="16" height="16" onclick="getHelp('xlmthIntersect.htm')" onmouseover="showReturns('Returns: Range')"><br>Iteration [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel will use iteration to resolve circular references. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIteration.htm')" onmouseover="showReturns('Returns: Boolean')"><br>LanguageSettings<input type="image" src="MSGBOX02.ICO" alt="Returns: LanguageSettings. Returns the LanguageSettings object, which contains information about the language settings in Microsoft Excel. Read-only." width="16" height="16" onclick="getHelp('xlproLanguageSettings.htm')" onmouseover="showReturns('Returns: LanguageSettings')"><br>LargeButtons [= 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>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>LibraryPath<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the path to the Library folder, but without the final separator. Read-only String." width="16" height="16" onclick="getHelp('xlproLibraryPath.htm')" onmouseover="showReturns('Returns: String')"><br>MacroOptions([Macro], [Description], [HasMenu], [MenuText], [HasShortcutKey], [ShortcutKey], [Category], [StatusBar], [HelpContextID], [HelpFile]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Corresponds to options in the Macro Options dialog box." width="16" height="16" onclick="getHelp('xlmthMacroOptions.htm')" onmouseover="showReturns('Returns: Void')"><br>MailLogoff() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Closes a MAPI mail session established by Microsoft Excel." width="16" height="16" onclick="getHelp('xlmthMailLogoff.htm')" onmouseover="showReturns('Returns: Void')"><br>MailLogon([Name], [Password], [DownloadNewMail]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Logs in to MAPI Mail or Microsoft Exchange and establishes a mail session. If Microsoft Mail isn't already running, you must use this method to establish a mail session before mail or document routing functions can be used." width="16" height="16" onclick="getHelp('xlmthMailLogon.htm')" onmouseover="showReturns('Returns: Void')"><br>MailSession<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the MAPI mail session number as a hexadecimal string (if there's an active session), or returns Null if there's no session. Read-only Variant." width="16" height="16" onclick="getHelp('xlproMailSession.htm')" onmouseover="showReturns('Returns: Object')"><br>MailSystem<input type="image" src="MSGBOX02.ICO" alt="Returns: XlMailSystem. This example displays the name of the mail system that's installed on the computer." width="16" height="16" onclick="getHelp('xlproMailSystem.htm')" onmouseover="showReturns('Returns: XlMailSystem')"><br>MapPaperSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if documents formatted for another country's/region's standard paper size (for example, A4) are automatically adjusted so that they're printed correctly on your country's/region's standard paper size (for example, Letter). Read/write Boolean." width="16" height="16" onclick="getHelp('xlproMapPaperSize.htm')" onmouseover="showReturns('Returns: Boolean')"><br>MathCoprocessorAvailable<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if a math coprocessor is available. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproMathCoprocessorAvailable.htm')" onmouseover="showReturns('Returns: Boolean')"><br>MaxChange [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references. Read/write Double." width="16" height="16" onclick="getHelp('xlproMaxChange.htm')" onmouseover="showReturns('Returns: Double')"><br>MaxIterations [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference. Read/write Long." width="16" height="16" onclick="getHelp('xlproMaxIterations.htm')" onmouseover="showReturns('Returns: Int32')"><br>MemoryFree<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the amount of memory that's still available for Microsoft Excel to use, in bytes. Read-only Long." width="16" height="16" onclick="getHelp('xlproMemoryFree.htm')" onmouseover="showReturns('Returns: Int32')"><br>MemoryTotal<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the total amount of memory (in bytes) that's available to Microsoft Excel, including memory already in use. Read-only Long." width="16" height="16" onclick="getHelp('xlproMemoryTotal.htm')" onmouseover="showReturns('Returns: Int32')"><br>MemoryUsed<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Application object: Returns the amount of memory that Microsoft Excel is currently using, in bytes. Read-only Long." width="16" height="16" onclick="getHelp('xlproMemoryUsed.htm')" onmouseover="showReturns('Returns: Int32')"><br>MenuBars<input type="image" src="MSGBOX02.ICO" alt="Returns: MenuBars. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: MenuBars')"><br>Modules<input type="image" src="MSGBOX02.ICO" alt="Returns: Modules. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Modules')"><br>MouseAvailable<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if a mouse is available. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproMouseAvailable.htm')" onmouseover="showReturns('Returns: Boolean')"><br>MoveAfterReturn [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the active cell will be moved as soon as the ENTER (RETURN) key is pressed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproMoveAfterReturn.htm')" onmouseover="showReturns('Returns: Boolean')"><br>MoveAfterReturnDirection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlDirection. If the MoveAfterReturn property is False, the selection doesnt move at all, regardless of how the MoveAfterReturnDirection property is set." width="16" height="16" onclick="getHelp('xlproMoveAfterReturnDirection.htm')" onmouseover="showReturns('Returns: XlDirection')"><br>Name<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>Names<input type="image" src="MSGBOX02.ICO" alt="Returns: Names. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproNames.htm')" onmouseover="showReturns('Returns: Names')"><br>NetworkTemplatesPath<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the network path where templates are stored. If the network path doesnt exist, this property returns an empty string. Read-only String." width="16" height="16" onclick="getHelp('xlproNetworkTemplatesPath.htm')" onmouseover="showReturns('Returns: String')"><br>NewWorkbook<input type="image" src="MSGBOX02.ICO" alt="Returns: NewFile. Returns a StartWorking object." width="16" height="16" onclick="getHelp('xlproNewWorkbook.htm')" onmouseover="showReturns('Returns: NewFile')"><br>NextLetter() <input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthNextLetter.htm')" onmouseover="showReturns('Returns: Workbook')"><br>ODBCErrors<input type="image" src="MSGBOX02.ICO" alt="Returns: ODBCErrors. Returns an ODBCErrors collection that contains all the ODBC errors generated by the most recent query table or PivotTable report operation. Read-only." width="16" height="16" onclick="getHelp('xlproODBCErrors.htm')" onmouseover="showReturns('Returns: ODBCErrors')"><br>ODBCTimeout [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the ODBC query time limit, in seconds. The default value is 45 seconds. Read/write Long." width="16" height="16" onclick="getHelp('xlproODBCTimeout.htm')" onmouseover="showReturns('Returns: Int32')"><br>OLEDBErrors<input type="image" src="MSGBOX02.ICO" alt="Returns: OLEDBErrors. Returns the OLEDBErrors collection, which represents the error information returned by the most recent OLE DB query. Read-only." width="16" height="16" onclick="getHelp('xlproOLEDBErrors.htm')" onmouseover="showReturns('Returns: OLEDBErrors')"><br>OnCalculate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnData [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnDoubleClick [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnEntry [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnKey(Key, [Procedure]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Runs a specified procedure when a particular key or key combination is pressed." width="16" height="16" onclick="getHelp('xlmthOnKey.htm')" onmouseover="showReturns('Returns: Void')"><br>OnRepeat(Text, Procedure) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the Repeat menu item and the name of the procedure that will run if you choose the Repeat command (Edit menu) after running the procedure that sets this property." width="16" height="16" onclick="getHelp('xlmthOnRepeat.htm')" onmouseover="showReturns('Returns: Void')"><br>OnSheetActivate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnSheetDeactivate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnTime(EarliestTime, Procedure, [LatestTime], [Schedule]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Schedules a procedure to be run at a specified time in the future (either at a specific time of day or after a specific amount of time has passed)." width="16" height="16" onclick="getHelp('xlmthOnTime.htm')" onmouseover="showReturns('Returns: Void')"><br>OnUndo(Text, Procedure) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the text of the Undo and the name of the procedure thats run if you choose the Undo command (Edit menu) after running the procedure that sets this property." width="16" height="16" onclick="getHelp('xlmthOnUndo.htm')" onmouseover="showReturns('Returns: Void')"><br>OnWindow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the procedure thats run whenever you activate a window. Read/write String." width="16" height="16" onclick="getHelp('xlproOnWindow.htm')" onmouseover="showReturns('Returns: String')"><br>OperatingSystem<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name and version number of the current operating system&amp;nbsp; for example, Windows (32-bit) 4.00 or Macintosh 7.00. Read-only String." width="16" height="16" onclick="getHelp('xlproOperatingSystem.htm')" onmouseover="showReturns('Returns: String')"><br>OrganizationName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the registered organization name. Read-only String." width="16" height="16" onclick="getHelp('xlproOrganizationName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Application')"><br>Path<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Path property as it applies to the AutoRecover object." width="16" height="16" onclick="getHelp('xlproPath.htm')" onmouseover="showReturns('Returns: String')"><br>PathSeparator<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the path separator character (\). Read-only String." width="16" height="16" onclick="getHelp('xlproPathSeparator.htm')" onmouseover="showReturns('Returns: String')"><br>PivotTableSelection [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if PivotTable reports use structured selection. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPivotTableSelection.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PreviousSelections<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an array of the last four ranges or names selected. Each element in the array is a Range object. Read-only Variant." width="16" height="16" onclick="getHelp('xlproPreviousSelections.htm')" onmouseover="showReturns('Returns: Object')"><br>ProductCode<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the globally unique identifier (GUID) for Microsoft Excel. Read-only String." width="16" height="16" onclick="getHelp('xlproProductCode.htm')" onmouseover="showReturns('Returns: String')"><br>PromptForSummaryInfo [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel asks for summary information when files are first saved. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPromptForSummaryInfo.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Quit() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Quits Microsoft Excel." width="16" height="16" onclick="getHelp('xlmthQuit.htm')" onmouseover="showReturns('Returns: Void')"><br>Range<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Although you can use the Shapes.Range(1)." width="16" height="16" onclick="getHelp('xlproRange.htm')" onmouseover="showReturns('Returns: Range')"><br>Ready<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproReady.htm')" onmouseover="showReturns('Returns: Boolean')"><br>RecentFiles<input type="image" src="MSGBOX02.ICO" alt="Returns: RecentFiles. Returns a RecentFiles collection that represents the list of recently used files." width="16" height="16" onclick="getHelp('xlproRecentFiles.htm')" onmouseover="showReturns('Returns: RecentFiles')"><br>RecordMacro([BasicCode], [XlmCode]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Records code if the macro recorder is on." width="16" height="16" onclick="getHelp('xlmthRecordMacro.htm')" onmouseover="showReturns('Returns: Void')"><br>RecordRelative<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if macros are recorded using relative references; False if recording is absolute. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproRecordRelative.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ReferenceStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlReferenceStyle. This example displays the current reference style." width="16" height="16" onclick="getHelp('xlproReferenceStyle.htm')" onmouseover="showReturns('Returns: XlReferenceStyle')"><br>RegisteredFunctions<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns information about functions in either dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID macro functions. Read-only Variant." width="16" height="16" onclick="getHelp('xlproRegisteredFunctions.htm')" onmouseover="showReturns('Returns: Object')"><br>RegisterXLL(Filename) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Loads an XLL code resource and automatically registers the functions and commands contained in the resource." width="16" height="16" onclick="getHelp('xlmthRegisterXLL.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Repeat() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Repeats the last user-interface action." width="16" height="16" onclick="getHelp('xlmthRepeat.htm')" onmouseover="showReturns('Returns: Void')"><br>ReplaceFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: CellFormat. Sets the replacement criteria to use in replacing cell formats." width="16" height="16" onclick="getHelp('xlproReplaceFormat.htm')" onmouseover="showReturns('Returns: CellFormat')"><br>ResetTipWizard() <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>RollZoom [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the IntelliMouse zooms instead of scrolling. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproRollZoom.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Rows<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. For an Application object, returns a Range object that represents all the rows on the active worksheet. If the active document isnt a worksheet, the Rows property fails. For a Range object, returns a Range object that represents the rows in the specified range. For a Worksheet object, returns a Range object that represents all the rows on the specified worksheet. Read-only Range object." width="16" height="16" onclick="getHelp('xlproRows.htm')" onmouseover="showReturns('Returns: Range')"><br>RTD<input type="image" src="MSGBOX02.ICO" alt="Returns: RTD. Returns an RTD object." width="16" height="16" onclick="getHelp('xlproRTD.htm')" onmouseover="showReturns('Returns: RTD')"><br>Run([Macro], [Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Runs the Microsoft Excel macro at this location. The range must be on a macro sheet." width="16" height="16" onclick="getHelp('xlmthRun.htm')" onmouseover="showReturns('Returns: Object')"><br>Save([Filename]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves changes to the specified workbook." width="16" height="16" onclick="getHelp('xlmthSave.htm')" onmouseover="showReturns('Returns: Void')"><br>SaveWorkspace([Filename]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves the current workspace." width="16" height="16" onclick="getHelp('xlmthSaveWorkspace.htm')" onmouseover="showReturns('Returns: Void')"><br>ScreenUpdating [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if screen updating is turned on. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproScreenUpdating.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Selection<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the selected object in the active window, for an Application object, and a specified window, for a Windows object." width="16" height="16" onclick="getHelp('xlproSelection.htm')" onmouseover="showReturns('Returns: Object')"><br>SendKeys(Keys, [Wait]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sends keystrokes to the active application." width="16" height="16" onclick="getHelp('xlmthSendKeys.htm')" onmouseover="showReturns('Returns: Void')"><br>SetDefaultChart([FormatName], [Gallery]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Specifies the name of the chart template that Microsoft Excel will use when creating new charts." width="16" height="16" onclick="getHelp('xlmthSetDefaultChart.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetActivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any sheet is activated." width="16" height="16" onclick="getHelp('xlevtSheetActivate.htm')" onmouseover="showReturns('Returns: ')"><br>SheetBeforeDoubleClick<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any worksheet is double-clicked, before the default double-click action." width="16" height="16" onclick="getHelp('xlevtSheetBeforeDoubleClick.htm')" onmouseover="showReturns('Returns: ')"><br>SheetBeforeRightClick<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any worksheet is right-clicked, before the default right-click action." width="16" height="16" onclick="getHelp('xlevtSheetBeforeRightClick.htm')" onmouseover="showReturns('Returns: ')"><br>SheetCalculate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after any worksheet is recalculated or after any changed data is plotted on a chart." width="16" height="16" onclick="getHelp('xlevtSheetCalculate.htm')" onmouseover="showReturns('Returns: ')"><br>SheetChange<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when cells in any worksheet are changed by the user or by an external link." width="16" height="16" onclick="getHelp('xlevtSheetChange.htm')" onmouseover="showReturns('Returns: ')"><br>SheetDeactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any sheet is deactivated." width="16" height="16" onclick="getHelp('xlevtSheetDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>SheetFollowHyperlink<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when you click any hyperlink in Microsoft Excel. For worksheet-level events, see the Help topic for the FollowHyperlink event." width="16" height="16" onclick="getHelp('xlevtSheetFollowHyperlink.htm')" onmouseover="showReturns('Returns: ')"><br>SheetPivotTableUpdate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after the sheet of the PivotTable report has been updated." width="16" height="16" onclick="getHelp('xlevtSheetPivotTableUpdate.htm')" onmouseover="showReturns('Returns: ')"><br>Sheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the sheets in the active workbook, for an Application object. Returns a Sheets collection that represents all the sheets in the specified workbook, for a Workbook object. Read-only Sheets object." width="16" height="16" onclick="getHelp('xlproSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>SheetSelectionChange<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet)." width="16" height="16" onclick="getHelp('xlevtSheetSelectionChange.htm')" onmouseover="showReturns('Returns: ')"><br>SheetsInNewWorkbook [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks. Read/write Long." width="16" height="16" onclick="getHelp('xlproSheetsInNewWorkbook.htm')" onmouseover="showReturns('Returns: Int32')"><br>ShortcutMenus<input type="image" src="MSGBOX02.ICO" alt="Returns: Menu. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Menu')"><br>ShowChartTipNames [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if charts show chart tip names. The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowChartTipNames.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowChartTipValues [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if charts show chart tip values. The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowChartTipValues.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowStartupDialog [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns True (default) when the New Workbook task pane appears for a Microsoft Excel application. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowStartupDialog.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowToolTips [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if ToolTips are turned on. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowToolTips.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowWindowsInTaskbar [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if theres a separate Windows taskbar button for each open workbook. The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowWindowsInTaskbar.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SmartTagRecognizers<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTagRecognizers. Returns a SmartTagRecognizers collection for an application." width="16" height="16" onclick="getHelp('xlproSmartTagRecognizers.htm')" onmouseover="showReturns('Returns: SmartTagRecognizers')"><br>Speech<input type="image" src="MSGBOX02.ICO" alt="Returns: Speech. Returns a Speech object." width="16" height="16" onclick="getHelp('xlproSpeech.htm')" onmouseover="showReturns('Returns: Speech')"><br>SpellingOptions<input type="image" src="MSGBOX02.ICO" alt="Returns: SpellingOptions. Returns a SpellingOptions object that represents the spelling options of the application." width="16" height="16" onclick="getHelp('xlproSpellingOptions.htm')" onmouseover="showReturns('Returns: SpellingOptions')"><br>StandardFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the standard font. Read/write String." width="16" height="16" onclick="getHelp('xlproStandardFont.htm')" onmouseover="showReturns('Returns: String')"><br>StandardFontSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the standard font size, in points. Read/write Long." width="16" height="16" onclick="getHelp('xlproStandardFontSize.htm')" onmouseover="showReturns('Returns: Double')"><br>StartupPath<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the complete path of the startup folder, excluding the final separator. Read-only String." width="16" height="16" onclick="getHelp('xlproStartupPath.htm')" onmouseover="showReturns('Returns: String')"><br>StatusBar [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the text in the status bar. Read/write String." width="16" height="16" onclick="getHelp('xlproStatusBar.htm')" onmouseover="showReturns('Returns: Object')"><br>Support(Object, ID, [arg]) <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>TemplatesPath<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the local path where templates are stored. Read-only String." width="16" height="16" onclick="getHelp('xlproTemplatesPath.htm')" onmouseover="showReturns('Returns: String')"><br>ThisCell<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns the cell in which the user-defined function is being called from as a Range object." width="16" height="16" onclick="getHelp('xlproThisCell.htm')" onmouseover="showReturns('Returns: Range')"><br>ThisWorkbook<input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. Returns a Workbook object that represents the workbook where the current macro code is running. Read-only." width="16" height="16" onclick="getHelp('xlproThisWorkbook.htm')" onmouseover="showReturns('Returns: Workbook')"><br>ThousandsSeparator [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Sets or returns&amp;nbsp;the character used for the thousands separator as a String. Read/write." width="16" height="16" onclick="getHelp('xlproThousandsSeparator.htm')" onmouseover="showReturns('Returns: String')"><br>Toolbars<input type="image" src="MSGBOX02.ICO" alt="Returns: Toolbars. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Toolbars')"><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>ToString() <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>TransitionMenuKey [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the Microsoft Excel menu or help key, which is usually /. Read/write String." width="16" height="16" onclick="getHelp('xlproTransitionMenuKey.htm')" onmouseover="showReturns('Returns: String')"><br>TransitionMenuKeyAction [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the action taken when the Microsoft Excel menu key is pressed. Can be either xlExcelMenus or xlLotusHelp. Read/write Long." width="16" height="16" onclick="getHelp('xlproTransitionMenuKeyAction.htm')" onmouseover="showReturns('Returns: Int32')"><br>TransitionNavigKeys [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if transition navigation keys are active. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproTransitionNavigKeys.htm')" onmouseover="showReturns('Returns: Boolean')"><br>UILanguage [= setting]<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>Undo() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Cancels the last user-interface action." width="16" height="16" onclick="getHelp('xlmthUndo.htm')" onmouseover="showReturns('Returns: Void')"><br>Union(Arg1, Arg2, [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns the union of two or more ranges." width="16" height="16" onclick="getHelp('xlmthUnion.htm')" onmouseover="showReturns('Returns: Range')"><br>UsableHeight<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproUsableHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>UsableWidth<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the maximum width of the space that a window can occupy in the application window area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproUsableWidth.htm')" onmouseover="showReturns('Returns: Double')"><br>UsedObjects<input type="image" src="MSGBOX02.ICO" alt="Returns: UsedObjects. Returns a UsedObjects object representing objects allocated in a workbook." width="16" height="16" onclick="getHelp('xlproUsedObjects.htm')" onmouseover="showReturns('Returns: UsedObjects')"><br>UserControl [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the application is visible or if it was created or started by the user. False if you created or started the application programmatically by using the CreateObject or GetObject functions, and the application is hidden. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproUserControl.htm')" onmouseover="showReturns('Returns: Boolean')"><br>UserLibraryPath<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the path to the location on the users computer where the COM add-ins are installed. Read-only String." width="16" height="16" onclick="getHelp('xlproUserLibraryPath.htm')" onmouseover="showReturns('Returns: String')"><br>UserName [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the current user. Read/write String." width="16" height="16" onclick="getHelp('xlproUserName.htm')" onmouseover="showReturns('Returns: String')"><br>UseSystemSeparators [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True (default) if the system separators of Microsoft Excel are enabled. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproUseSystemSeparators.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Value<input type="image" src="MSGBOX02.ICO" alt="Returns: String. 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: String')"><br>VBE<input type="image" src="MSGBOX02.ICO" alt="Returns: VBE. " width="16" height="16" onclick="getHelp('xlproVBE.htm')" onmouseover="showReturns('Returns: VBE')"><br>Version<input type="image" src="MSGBOX02.ICO" alt="Returns: String. &amp;nbsp;Version property as it applies to the PivotTable object." width="16" height="16" onclick="getHelp('xlproVersion.htm')" onmouseover="showReturns('Returns: String')"><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>Volatile([Volatile]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell." width="16" height="16" onclick="getHelp('xlmthVolatile.htm')" onmouseover="showReturns('Returns: Void')"><br>Wait(Time) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Pauses a running macro until a specified time. Returns True if the specified time has arrived." width="16" height="16" onclick="getHelp('xlmthWait.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Watches<input type="image" src="MSGBOX02.ICO" alt="Returns: Watches. Returns a Watches object representing a range which is tracked when the worksheet is recalculated." width="16" height="16" onclick="getHelp('xlproWatches.htm')" onmouseover="showReturns('Returns: Watches')"><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>WindowActivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook window is activated." width="16" height="16" onclick="getHelp('xlevtWindowActivate.htm')" onmouseover="showReturns('Returns: ')"><br>WindowDeactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook window is deactivated." width="16" height="16" onclick="getHelp('xlevtWindowDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>WindowResize<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook window is resized." width="16" height="16" onclick="getHelp('xlevtWindowResize.htm')" onmouseover="showReturns('Returns: ')"><br>Windows<input type="image" src="MSGBOX02.ICO" alt="Returns: Windows. For an Application object, returns a Windows collection that represents all the windows in all the workbooks. For a Workbook object, returns a Windows collection that represents all the windows in the specified workbook. Read-only Windows object." width="16" height="16" onclick="getHelp('xlproWindows.htm')" onmouseover="showReturns('Returns: Windows')"><br>WindowsForPens<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the computer is running under Microsoft Windows for Pen Computing. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproWindowsForPens.htm')" onmouseover="showReturns('Returns: Boolean')"><br>WindowState [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlWindowState. This example maximizes the application window in Microsoft Excel." width="16" height="16" onclick="getHelp('xlproWindowState.htm')" onmouseover="showReturns('Returns: XlWindowState')"><br>WorkbookActivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook is activated." width="16" height="16" onclick="getHelp('xlevtWorkbookActivate.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookAddinInstall<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when a workbook is installed as an add-in." width="16" height="16" onclick="getHelp('xlevtWorkbookAddinInstall.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookAddinUninstall<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any add-in workbook is uninstalled." width="16" height="16" onclick="getHelp('xlevtWorkbookAddinUninstall.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookAfterXmlExport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookAfterXmlImport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookBeforeClose<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs immediately before any open workbook closes." width="16" height="16" onclick="getHelp('xlevtWorkbookBeforeClose.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookBeforePrint<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs before any open workbook is printed." width="16" height="16" onclick="getHelp('xlevtWorkbookBeforePrint.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookBeforeSave<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs before any open workbook is saved." width="16" height="16" onclick="getHelp('xlevtWorkbookBeforeSave.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookBeforeXmlExport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookBeforeXmlImport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookDeactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any open workbook is deactivated." width="16" height="16" onclick="getHelp('xlevtWorkbookDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookNewSheet<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when a new sheet is created in any open workbook." width="16" height="16" onclick="getHelp('xlevtWorkbookNewSheet.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookOpen<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when a workbook is opened." width="16" height="16" onclick="getHelp('xlevtWorkbookOpen.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookPivotTableCloseConnection<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after a PivotTable report connection has been closed." width="16" height="16" onclick="getHelp('xlevtWorkbookPivotTableCloseConnection.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookPivotTableOpenConnection<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlevtWorkbookPivotTableOpenConnection.htm')" onmouseover="showReturns('Returns: ')"><br>Workbooks<input type="image" src="MSGBOX02.ICO" alt="Returns: Workbooks. Returns a Workbooks collection that represents all the open workbooks. Read-only." width="16" height="16" onclick="getHelp('xlproWorkbooks.htm')" onmouseover="showReturns('Returns: Workbooks')"><br>WorkbookSync<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>WorksheetFunction<input type="image" src="MSGBOX02.ICO" alt="Returns: WorksheetFunction. Returns the WorksheetFunction object. Read-only." width="16" height="16" onclick="getHelp('xlproWorksheetFunction.htm')" onmouseover="showReturns('Returns: WorksheetFunction')"><br>Worksheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. For an Application object, returns a Sheets collection that represents all the worksheets in the active workbook. For a Workbook object, returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object." width="16" height="16" onclick="getHelp('xlproWorksheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br><h2>AutoCorrect (1995) <img src="MSGBOX02.ICO" alt="Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on)." width="16" height="16" onclick="getHelp('xlobjAutoCorrect.htm');showMozHelp('Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).');"></h2>AddReplacement(What, Replacement) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Adds an entry to the array of AutoCorrect replacements." width="16" height="16" onclick="getHelp('xlmthAddReplacement.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>AutoExpandListRange [= 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>CapitalizeNamesOfDays [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the first letter of day names is capitalized automatically. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproCapitalizeNamesOfDays.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CorrectCapsLock [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel automatically corrects accidental use of the CAPS LOCK key. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproCorrectCapsLock.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CorrectSentenceCap [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel automatically corrects sentence (first word) capitalization. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproCorrectSentenceCap.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>DeleteReplacement(What) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deletes an entry from the array of AutoCorrect replacements." width="16" height="16" onclick="getHelp('xlmthDeleteReplacement.htm')" onmouseover="showReturns('Returns: Object')"><br>DisplayAutoCorrectOptions [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Allows the user to display or hide the AutoCorrect Options button.&amp;nbsp;The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayAutoCorrectOptions.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>ReplacementList [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the array of AutoCorrect replacements." width="16" height="16" onclick="getHelp('xlproReplacementList.htm')" onmouseover="showReturns('Returns: Object')"><br>ReplaceText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if text in the list of AutoCorrect replacements is replaced automatically. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproReplaceText.htm')" onmouseover="showReturns('Returns: Boolean')"><br>TwoInitialCapitals [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if words that begin with two capital letters are corrected automatically. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproTwoInitialCapitals.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>AutoRecover (2002) <img src="MSGBOX02.ICO" alt="Use the Path property of the AutoRecover object to set the path for where the AutoRecover file will be saved. The following example sets the path of the AutoRecover file to drive C." width="16" height="16" onclick="getHelp('xlobjAutoRecover.htm');showMozHelp('Use the Path property of the AutoRecover object to set the path for where the AutoRecover file will be saved. The following example sets the path of the AutoRecover file to drive C.');"></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>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>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>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>Path [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Path property as it applies to the AutoRecover object." width="16" height="16" onclick="getHelp('xlproPath.htm')" onmouseover="showReturns('Returns: String')"><br>Time [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Sets or returns the time interval for the AutoRecover object. Permissible values are integers from 1 to 120 minutes.&amp;nbsp;The default value is 10 minutes.&amp;nbsp;Read/write Long." width="16" height="16" onclick="getHelp('xlproTime.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>CellFormat (2002) <img src="MSGBOX02.ICO" alt="Represents the search criteria for the cell format." width="16" height="16" onclick="getHelp('xlobjCellFormat.htm');showMozHelp('Represents the search criteria for the cell format.');"></h2>AddIndent [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: 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>Borders [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Borders. For information about returning a single member of a collection, see Returning an Object from a Collection." width="16" height="16" onclick="getHelp('xlproBorders.htm')" onmouseover="showReturns('Returns: Borders')"><br>Clear() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example clears the formulas and formatting in cells A1:G37 on Sheet1." width="16" height="16" onclick="getHelp('xlmthClear.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>Font [= setting]<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>FormulaHidden [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. FormulaHidden property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproFormulaHidden.htm')" onmouseover="showReturns('Returns: Object')"><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 have selected or installed." width="16" height="16" onclick="getHelp('xlproHorizontalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br>IndentLevel [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. IndentLevel property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproIndentLevel.htm')" onmouseover="showReturns('Returns: Object')"><br>Interior [= setting]<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>Locked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>MergeCells [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the range or style contains merged cells. Read/write Variant." width="16" height="16" onclick="getHelp('xlproMergeCells.htm')" onmouseover="showReturns('Returns: Object')"><br>NumberFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormat property as it applies to the DataLabel, DataLabels, PivotField, Style, and TickLabels objects." width="16" height="16" onclick="getHelp('xlproNumberFormat.htm')" onmouseover="showReturns('Returns: Object')"><br>NumberFormatLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormatLocal property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproNumberFormatLocal.htm')" onmouseover="showReturns('Returns: Object')"><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>ShrinkToFit [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example causes text in row one to automatically shrink to fit in the available column width." width="16" height="16" onclick="getHelp('xlproShrinkToFit.htm')" onmouseover="showReturns('Returns: Object')"><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 have selected or installed." width="16" height="16" onclick="getHelp('xlproVerticalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br>WrapText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. WrapText property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproWrapText.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>ErrorCheckingOptions (2002) <img src="MSGBOX02.ICO" alt="Represents the error-checking options for an application." width="16" height="16" onclick="getHelp('xlobjErrorCheckingOptions.htm');showMozHelp('Represents the error-checking options for an application.');"></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>BackgroundChecking [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Alerts the user for all cells that violate enabled error checking rules. When this property is set to True (default), the AutoCorrect Options button appears next to all cells that violate enabled errors. False disables background checking for errors. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproBackgroundChecking.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>EmptyCellReferences [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells containing formulas that refer to empty cells. False disables empty cell reference checking. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEmptyCellReferences.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EvaluateToError [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells that contain formulas evaluating to an error. False disables error checking for cells that evaluate to an error value. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEvaluateToError.htm')" onmouseover="showReturns('Returns: Boolean')"><br>InconsistentFormula [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies cells containing an inconsistent formula in a region.&amp;nbsp;False disables the inconsistent formula check. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproInconsistentFormula.htm')" onmouseover="showReturns('Returns: Boolean')"><br>IndicatorColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. The following illustration shows the color-index values in the default color palette." width="16" height="16" onclick="getHelp('xlproIndicatorColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><br>ListDataValidation [= 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>NumberAsText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells that contain numbers written as text. False disables error checking for numbers written as text. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproNumberAsText.htm')" onmouseover="showReturns('Returns: Boolean')"><br>OmittedCells [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, the selected cells that contain formulas referring to a range that omits adjacent cells that could be included. False disables error checking for omitted cells. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproOmittedCells.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>TextDate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, cells that contain a text date with a two-digit year. False disables error checking for cells containing a text date with a two-digit year. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproTextDate.htm')" onmouseover="showReturns('Returns: Boolean')"><br>UnlockedFormulaCells [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True (default), Microsoft Excel identifies selected cells that are unlocked and contain a formula. False disables error checking for unlocked cells that contain formulas. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproUnlockedFormulaCells.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>Pane (1995) <img src="MSGBOX02.ICO" alt="Represents a pane of a window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets. The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single window." width="16" height="16" onclick="getHelp('xlobjPane.htm');showMozHelp('Represents a pane of a window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets. The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single window.');"></h2>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.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>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>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>LargeScroll([Down], [Up], [ToRight], [ToLeft]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Scrolls the contents of the window by pages." width="16" height="16" onclick="getHelp('xlmthLargeScroll.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>ScrollColumn [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of the leftmost column in the pane or window. Read/write Long." width="16" height="16" onclick="getHelp('xlproScrollColumn.htm')" onmouseover="showReturns('Returns: Int32')"><br>ScrollIntoView(Left, Top, Width, Height, [Start]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Scrolls the document window so that the contents of a specified rectangular area are displayed in either the upper-left or lower-right corner of the document window or pane (depending on the value of the Start argument)." width="16" height="16" onclick="getHelp('xlmthScrollIntoView.htm')" onmouseover="showReturns('Returns: Void')"><br>ScrollRow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of the row that appears at the top of the pane or window. Read/write Long." width="16" height="16" onclick="getHelp('xlproScrollRow.htm')" onmouseover="showReturns('Returns: Int32')"><br>SmallScroll([Down], [Up], [ToRight], [ToLeft]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Scrolls the contents of the window by rows or columns." width="16" height="16" onclick="getHelp('xlmthSmallScroll.htm')" onmouseover="showReturns('Returns: Object')"><br>VisibleRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the range of cells that are visible in the window or pane. If a column or row is partially visible, it's included in the range. Read-only." width="16" height="16" onclick="getHelp('xlproVisibleRange.htm')" onmouseover="showReturns('Returns: Range')"><br><h2>Panes (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Pane objects shown in the specified window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets." width="16" height="16" onclick="getHelp('xlobjPanes.htm');showMozHelp('A collection of all the Pane objects shown in the specified window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets.');"></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>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Pane. 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: Pane')"><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>RecentFile (1997) <img src="MSGBOX02.ICO" alt="Represents a file in the list of recently used files. The RecentFile object is a member of the RecentFiles collection." width="16" height="16" onclick="getHelp('xlobjRecentFile.htm');showMozHelp('Represents a file in the list of recently used files. The RecentFile object is a member of the RecentFiles collection.');"></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>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>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>Name<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>Open() <input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. This example opens the workbook Analysis.xls and then runs its Auto_Open macro." width="16" height="16" onclick="getHelp('xlmthOpen.htm')" onmouseover="showReturns('Returns: Workbook')"><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>Path<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Path property as it applies to the AutoRecover object." width="16" height="16" onclick="getHelp('xlproPath.htm')" onmouseover="showReturns('Returns: String')"><br><h2>RecentFiles (1997) <img src="MSGBOX02.ICO" alt="Represents the list of recently used files. Each file is represented by a RecentFile object." width="16" height="16" onclick="getHelp('xlobjRecentFiles.htm');showMozHelp('Represents the list of recently used files. Each file is represented by a RecentFile object.');"></h2>Add(Name) <input type="image" src="MSGBOX02.ICO" alt="Returns: RecentFile. 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: RecentFile')"><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>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: RecentFile. 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: RecentFile')"><br>Maximum [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the maximum number of files in the list of recently used files. Can be a value from 0 (zero) through 9. Read/write Long." width="16" height="16" onclick="getHelp('xlproMaximum.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><h2>Sheets (1995) <img src="MSGBOX02.ICO" alt="A collection of all the sheets in the specified or active workbook. The Sheets collection can contain Worksheet objects." width="16" height="16" onclick="getHelp('xlobjSheets.htm');showMozHelp('A collection of all the sheets in the specified or active workbook. The Sheets collection can contain Worksheet objects.');"></h2>Add([Before], [After], [Count], [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: 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>Copy([Before], [After]) <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>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>FillAcrossSheets(Range, [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example fills the range A1:C5 on Sheet1, Sheet5, and Sheet7 with the contents of the same range on Sheet1." width="16" height="16" onclick="getHelp('xlmthFillAcrossSheets.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>HPageBreaks<input type="image" src="MSGBOX02.ICO" alt="Returns: HPageBreaks. Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only." width="16" height="16" onclick="getHelp('xlproHPageBreaks.htm')" onmouseover="showReturns('Returns: HPageBreaks')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Move([Before], [After]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Moves the sheet to another location in the workbook." width="16" height="16" onclick="getHelp('xlmthMove.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>PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Prints the object." width="16" height="16" onclick="getHelp('xlmthPrintOut.htm')" onmouseover="showReturns('Returns: Void')"><br>PrintPreview([EnableChanges]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Shows a preview of the object as it would look when printed." width="16" height="16" onclick="getHelp('xlmthPrintPreview.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>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>VPageBreaks<input type="image" src="MSGBOX02.ICO" alt="Returns: VPageBreaks. Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only." width="16" height="16" onclick="getHelp('xlproVPageBreaks.htm')" onmouseover="showReturns('Returns: VPageBreaks')"><br><h2>Speech (2002) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlobjSpeech.htm');showMozHelp('Hidden or unsupported element.');"></h2>Direction [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSpeakDirection. Returns or sets the order in which the cells will be spoken. &amp;nbsp;The value of the Direction property is an constant. Read/write. " width="16" height="16" onclick="getHelp('xlproDirection.htm')" onmouseover="showReturns('Returns: XlSpeakDirection')"><br>Speak(Text, [SpeakAsync], [SpeakXML], [Purge]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Causes the cells of the range to be spoken in row order or column order. " width="16" height="16" onclick="getHelp('xlmthSpeak.htm')" onmouseover="showReturns('Returns: Void')"><br>SpeakCellOnEnter [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Microsoft Excel supports a mode where the active cell will be spoken when the ENTER key is pressed or when the active cell is finished being edited. &amp;nbsp;Setting the SpeakCellOnEnter property to True will turn this mode on. &amp;nbsp;False turns this mode off. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproSpeakCellOnEnter.htm')" onmouseover="showReturns('Returns: Boolean')"><br><h2>SpellingOptions (2002) <img src="MSGBOX02.ICO" alt="Represents the various spell checking options for a worksheet." width="16" height="16" onclick="getHelp('xlobjSpellingOptions.htm');showMozHelp('Represents the various spell checking options for a worksheet.');"></h2>ArabicModes [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlArabicModes. Returns or sets the mode for the Arabic spelling checker. Read/write XlArabicModes." width="16" height="16" onclick="getHelp('xlproArabicModes.htm')" onmouseover="showReturns('Returns: XlArabicModes')"><br>DictLang [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Selects the dictionary language used, when Microsoft Excel performs spelling checks. Read/write Long." width="16" height="16" onclick="getHelp('xlproDictLang.htm')" onmouseover="showReturns('Returns: Int32')"><br>GermanPostReform [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to check the spelling of words using the German post-reform rules. False cancels this feature. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproGermanPostReform.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HebrewModes [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlHebrewModes. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproHebrewModes.htm')" onmouseover="showReturns('Returns: XlHebrewModes')"><br>IgnoreCaps [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. False instructs Microsoft Excel to check for uppercase words, True instructs Excel to ignore words in uppercase when using the spelling checker. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIgnoreCaps.htm')" onmouseover="showReturns('Returns: Boolean')"><br>IgnoreFileNames [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. False instructs Microsoft Excel to check for Internet and file addresses, True instructs Excel to ignore Internet and file addresses when using the spell checker. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIgnoreFileNames.htm')" onmouseover="showReturns('Returns: Boolean')"><br>IgnoreMixedDigits [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. False instructs Microsoft Excel to check for mixed digits, True instructs Excel to ignore mixed digits when checking spelling. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIgnoreMixedDigits.htm')" onmouseover="showReturns('Returns: Boolean')"><br>KoreanCombineAux [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True, this enables Microsoft Excel to combine Korean auxiliary verbs and adjectives when using the spelling checker. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproKoreanCombineAux.htm')" onmouseover="showReturns('Returns: Boolean')"><br>KoreanProcessCompound [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True, this enables Microsoft Excel to process Korean compound nouns when using the spelling checker. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproKoreanProcessCompound.htm')" onmouseover="showReturns('Returns: Boolean')"><br>KoreanUseAutoChangeList [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True, this enables Microsoft Excel to use the auto-change list for Korean words when using the spelling checker. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproKoreanUseAutoChangeList.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SuggestMainOnly [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. When set to True, instructs Microsoft Excel to suggest words from only the main dictionary, for using the spelling checker. False removes the limits of suggesting words from only the main dictionary, for using the spelling checker. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproSuggestMainOnly.htm')" onmouseover="showReturns('Returns: Boolean')"><br>UserDict [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Instructs Microsoft Excel to create a custom dictionary to which new words can be added to, when performing spelling checks on a worksheet. Read/write String." width="16" height="16" onclick="getHelp('xlproUserDict.htm')" onmouseover="showReturns('Returns: String')"><br><h2>Watch (2002) <img src="MSGBOX02.ICO" alt="Represents a range which is tracked when the worksheet is recalculated. The Watch object allows users to verify the accuracy of their models and debug problems they encounter. The Watch object is a member of the Watches collection." width="16" height="16" onclick="getHelp('xlobjWatch.htm');showMozHelp('Represents a range which is tracked when the worksheet is recalculated. The Watch object allows users to verify the accuracy of their models and debug problems they encounter. The Watch object is a member of the Watches collection.');"></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>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>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>Source<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Source property as it applies to the PublishObject object." width="16" height="16" onclick="getHelp('xlproSource.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Watches (2002) <img src="MSGBOX02.ICO" alt="A collection of all the Watch objects in a specified application." width="16" height="16" onclick="getHelp('xlobjWatches.htm');showMozHelp('A collection of all the Watch objects in a specified application.');"></h2>Add(Source) <input type="image" src="MSGBOX02.ICO" alt="Returns: Watch. 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: Watch')"><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>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>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: Watch. 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: Watch')"><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>Window (1995) <img src="MSGBOX02.ICO" alt="Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window. The Window object is a member of the Windows collection. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook. " width="16" height="16" onclick="getHelp('xlobjWindow.htm');showMozHelp('Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window. The Window object is a member of the Windows collection. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook. ');"></h2>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.htm')" onmouseover="showReturns('Returns: Object')"><br>ActivateNext() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Activates the specified window and then sends it to the back of the window z-order." width="16" height="16" onclick="getHelp('xlmthActivateNext.htm')" onmouseover="showReturns('Returns: Object')"><br>ActivatePrevious() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Activates the specified window and then activates the window at the back of the window z-order." width="16" height="16" onclick="getHelp('xlmthActivatePrevious.htm')" onmouseover="showReturns('Returns: Object')"><br>ActiveCell<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window isn't displaying a worksheet, this property fails. Read-only." width="16" height="16" onclick="getHelp('xlproActiveCell.htm')" onmouseover="showReturns('Returns: Range')"><br>ActiveChart<input type="image" src="MSGBOX02.ICO" alt="Returns: Chart. Returns a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns Nothing. Read-only." width="16" height="16" onclick="getHelp('xlproActiveChart.htm')" onmouseover="showReturns('Returns: Chart')"><br>ActivePane<input type="image" src="MSGBOX02.ICO" alt="Returns: Pane. Returns a Pane object that represents the active pane in the window. Read-only." width="16" height="16" onclick="getHelp('xlproActivePane.htm')" onmouseover="showReturns('Returns: Pane')"><br>ActiveSheet<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only." width="16" height="16" onclick="getHelp('xlproActiveSheet.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>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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: Object')"><br>Close([SaveChanges], [Filename], [RouteWorkbook]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Closing a workbook from Visual Basic doesn't run any Auto_Close macros in the workbook. Use the RunAutoMacros method to run the auto close macros." width="16" height="16" onclick="getHelp('xlmthClose.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>DisplayFormulas [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the window is displaying formulas, False if the window is displaying values. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayFormulas.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayGridlines [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if gridlines are displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayGridlines.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayHeadings [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if both row and column headings are displayed, False if there are no headings displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayHeadings.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayHorizontalScrollBar [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the horizontal scroll bar is displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayHorizontalScrollBar.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayOutline [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if outline symbols are displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayOutline.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayRightToLeft [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the specified window or worksheet is displayed from right to left instead of from left to right. False if the object is displayed from left to right. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayRightToLeft.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayVerticalScrollBar [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the vertical scroll bar is displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayVerticalScrollBar.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayWorkbookTabs [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook tabs are displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayWorkbookTabs.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayZeros [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if zero values are displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayZeros.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EnableResize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the window can be resized. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableResize.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FreezePanes [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if split panes are frozen. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproFreezePanes.htm')" onmouseover="showReturns('Returns: Boolean')"><br>GridlineColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the gridline color as an RGB value. Read/write Long." width="16" height="16" onclick="getHelp('xlproGridlineColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>GridlineColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. Set this property to xlColorIndexAutomatic to specify the automatic color." width="16" height="16" onclick="getHelp('xlproGridlineColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><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>LargeScroll([Down], [Up], [ToRight], [ToLeft]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Scrolls the contents of the window by pages." width="16" height="16" onclick="getHelp('xlmthLargeScroll.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>NewWindow() <input type="image" src="MSGBOX02.ICO" alt="Returns: Window. Creates a new window or a copy of the specified window." width="16" height="16" onclick="getHelp('xlmthNewWindow.htm')" onmouseover="showReturns('Returns: Window')"><br>OnWindow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the name of the procedure thats run whenever you activate a window. Read/write String." width="16" height="16" onclick="getHelp('xlproOnWindow.htm')" onmouseover="showReturns('Returns: String')"><br>Panes<input type="image" src="MSGBOX02.ICO" alt="Returns: Panes. Returns a Panes collection that represents all the panes in the specified window. Read-only." width="16" height="16" onclick="getHelp('xlproPanes.htm')" onmouseover="showReturns('Returns: Panes')"><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>PointsToScreenPixelsX(Points) <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Converts a horizontal measurement from points (document coordinates) to screen pixels (screen coordinates). Returns the converted measurement as a Long value." width="16" height="16" onclick="getHelp('xlmthPointsToScreenPixelsX.htm')" onmouseover="showReturns('Returns: Int32')"><br>PointsToScreenPixelsY(Points) <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Converts a vertical measurement from points (document coordinates) to screen pixels (screen coordinates). Returns the converted measurement as a Long value." width="16" height="16" onclick="getHelp('xlmthPointsToScreenPixelsY.htm')" onmouseover="showReturns('Returns: Int32')"><br>PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Prints the object." width="16" height="16" onclick="getHelp('xlmthPrintOut.htm')" onmouseover="showReturns('Returns: Object')"><br>PrintPreview([EnableChanges]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Shows a preview of the object as it would look when printed." width="16" height="16" onclick="getHelp('xlmthPrintPreview.htm')" onmouseover="showReturns('Returns: Object')"><br>RangeFromPoint(x, y) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the Range object that is positioned at the specified pair of screen coordinates. If there isnt a shape located at the specified coordinates, this method returns Nothing." width="16" height="16" onclick="getHelp('xlmthRangeFromPoint.htm')" onmouseover="showReturns('Returns: Object')"><br>RangeSelection<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the selected cells on the worksheet in the specified window even if a graphic object is active or selected on the worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproRangeSelection.htm')" onmouseover="showReturns('Returns: Range')"><br>ScrollColumn [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of the leftmost column in the pane or window. Read/write Long." width="16" height="16" onclick="getHelp('xlproScrollColumn.htm')" onmouseover="showReturns('Returns: Int32')"><br>ScrollIntoView(Left, Top, Width, Height, [Start]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Scrolls the document window so that the contents of a specified rectangular area are displayed in either the upper-left or lower-right corner of the document window or pane (depending on the value of the Start argument)." width="16" height="16" onclick="getHelp('xlmthScrollIntoView.htm')" onmouseover="showReturns('Returns: Void')"><br>ScrollRow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of the row that appears at the top of the pane or window. Read/write Long." width="16" height="16" onclick="getHelp('xlproScrollRow.htm')" onmouseover="showReturns('Returns: Int32')"><br>ScrollWorkbookTabs([Sheets], [Position]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Scrolls through the workbook tabs at the bottom of the window. Doesn't affect the active sheet in the workbook." width="16" height="16" onclick="getHelp('xlmthScrollWorkbookTabs.htm')" onmouseover="showReturns('Returns: Object')"><br>SelectedSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the selected sheets in the specified window. Read-only." width="16" height="16" onclick="getHelp('xlproSelectedSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>Selection<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the selected object in the active window, for an Application object, and a specified window, for a Windows object." width="16" height="16" onclick="getHelp('xlproSelection.htm')" onmouseover="showReturns('Returns: Object')"><br>SmallScroll([Down], [Up], [ToRight], [ToLeft]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Scrolls the contents of the window by rows or columns." width="16" height="16" onclick="getHelp('xlmthSmallScroll.htm')" onmouseover="showReturns('Returns: Object')"><br>Split [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the window is split. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproSplit.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SplitColumn [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the column number where the window is split into panes (the number of columns to the left of the split line). Read/write Long." width="16" height="16" onclick="getHelp('xlproSplitColumn.htm')" onmouseover="showReturns('Returns: Int32')"><br>SplitHorizontal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the location of the horizontal window split, in points. Read/write Double." width="16" height="16" onclick="getHelp('xlproSplitHorizontal.htm')" onmouseover="showReturns('Returns: Double')"><br>SplitRow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the row number where the window is split into panes (the number of rows above the split). Read/write Long." width="16" height="16" onclick="getHelp('xlproSplitRow.htm')" onmouseover="showReturns('Returns: Int32')"><br>SplitVertical [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the location of the vertical window split, in points. Read/write Double." width="16" height="16" onclick="getHelp('xlproSplitVertical.htm')" onmouseover="showReturns('Returns: Double')"><br>TabRatio [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; the default value is 0.6). Read/write Double." width="16" height="16" onclick="getHelp('xlproTabRatio.htm')" onmouseover="showReturns('Returns: Double')"><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>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: XlWindowType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: XlWindowType')"><br>UsableHeight<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproUsableHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>UsableWidth<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the maximum width of the space that a window can occupy in the application window area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproUsableWidth.htm')" onmouseover="showReturns('Returns: Double')"><br>View [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlWindowView. This example switches the view in the active window to page break preview." width="16" height="16" onclick="getHelp('xlproView.htm')" onmouseover="showReturns('Returns: XlWindowView')"><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>VisibleRange<input type="image" src="MSGBOX02.ICO" alt="Returns: Range. Returns a Range object that represents the range of cells that are visible in the window or pane. If a column or row is partially visible, it's included in the range. Read-only." width="16" height="16" onclick="getHelp('xlproVisibleRange.htm')" onmouseover="showReturns('Returns: Range')"><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>WindowNumber<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the window number. For example, a window named Book1.xls:2 has 2 as its window number. Most windows have the window number 1. Read-only Long." width="16" height="16" onclick="getHelp('xlproWindowNumber.htm')" onmouseover="showReturns('Returns: Int32')"><br>WindowState [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlWindowState. This example maximizes the application window in Microsoft Excel." width="16" height="16" onclick="getHelp('xlproWindowState.htm')" onmouseover="showReturns('Returns: XlWindowState')"><br>Zoom [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets. Read/write Variant." width="16" height="16" onclick="getHelp('xlproZoom.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Windows (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Window objects in Microsoft Excel. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook." width="16" height="16" onclick="getHelp('xlobjWindows.htm');showMozHelp('A collection of all the Window objects in Microsoft Excel. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook.');"></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>Arrange([ArrangeStyle], [ActiveWorkbook], [SyncHorizontal], [SyncVertical]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Arranges the windows on the screen. Varint." width="16" height="16" onclick="getHelp('xlmthArrange.htm')" onmouseover="showReturns('Returns: Object')"><br>BreakSideBySide() <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>CompareSideBySideWith(WindowName) <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>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: Window. 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: Window')"><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>ResetPositionsSideBySide() <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>SyncScrollingSideBySide [= 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></body> </html>