Application Property TOC - A

Application ActiveCell Property

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.

See Application ActiveCell Property

Application ActiveChart Property

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.

See Application ActiveChart Property

Application ActiveEncryptionSession Property

Returns a Long that represents the encryption session associated with the active document. Read-only.

See Application ActiveEncryptionSession Property

Application ActivePrinter Property

Returns or sets the name of the active printer. Read/write String.

See Application ActivePrinter Property

Application ActiveProtectedViewWindow Property

Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Read-only. Returns Nothing if there are no Protected View windows open. Read-only

See Application ActiveProtectedViewWindow Property

Application ActiveSheet Property

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.

See Application ActiveSheet Property

Application ActiveWindow Property

Returns a Window object that represents the active window (the window on top). Read-only. Returns Nothing if there are no windows open.

See Application ActiveWindow Property

Application ActiveWorkbook Property

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. Note The document in the active protected view window cannot be accessed using this property. Instead, use the Workbook property of the ProtectedViewWindow object.

See Application ActiveWorkbook Property

Application AddIns Property

Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Add-Ins command on the Developer tab). Read-only.

See Application AddIns Property

Application AddIns2 Property

Returns an AddIns2 collection that represents all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Read-only

See Application AddIns2 Property

Application AlertBeforeOverwriting Property

True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation. Read/write Boolean.

See Application AlertBeforeOverwriting Property

Application AltStartupPath Property

Returns or sets the name of the alternate startup folder. Read/write String.

See Application AltStartupPath Property

Application AlwaysUseClearType Property

Returns or sets a Boolean that represents whether to use ClearType to display fonts in the menu, ribbon, and dialog box text. Read/write Boolean.

See Application AlwaysUseClearType Property

Application Application Property

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When 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 the application of that object). Read-only.

See Application Application Property

Application ArbitraryXMLSupportAvailable Property

Returns a Boolean value that indicates whether the XML features in Microsoft Excel are available. Read-only.

See Application ArbitraryXMLSupportAvailable Property

Application AskToUpdateLinks Property

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.

See Application AskToUpdateLinks Property

Application Assistance Property

Returns an IAssistance object for Microsoft Excel that represents the Microsoft Office Help Viewer. Read-only.

See Application Assistance Property

Application AutoCorrect Property

Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes. Read-only.

See Application AutoCorrect Property

Application AutoFormatAsYouTypeReplaceHyperlinks Property

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.

See Application AutoFormatAsYouTypeReplaceHyperlinks Property

Application AutomationSecurity Property

Returns or sets an MsoAutomationSecurity constant that represents the security mode Microsoft Excel uses when programmatically opening files. Read/write.

See Application AutomationSecurity Property

Application AutoPercentEntry Property

True if entries in cells formatted as percentages aren’t automatically multiplied by 100 as soon as they are entered. Read/write Boolean.

See Application AutoPercentEntry Property

Application AutoRecover Property

Returns an AutoRecover object, which backs up all file formats on a timed interval.

See Application AutoRecover Property