Application Properties (Excel)

Article
05/23/2016

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Properties

Name	Description
ActiveCell	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.
ActiveChart	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.
ActiveEncryptionSession	Returns a Long that represents the encryption session associated with the active document. Read-only.
ActivePrinter	Returns or sets the name of the active printer. Read/write String.
ActiveProtectedViewWindow	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
ActiveSheet	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.
ActiveWindow	Returns a Window object that represents the active window (the window on top). Read-only. Returns Nothing if there are no windows open.
ActiveWorkbook	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.
AddIns	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.
AddIns2	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
AlertBeforeOverwriting	True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation. Read/write Boolean.
AltStartupPath	Returns or sets the name of the alternate startup folder. Read/write String.
AlwaysUseClearType	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.
Application	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.
ArbitraryXMLSupportAvailable	Returns a Boolean value that indicates whether the XML features in Microsoft Excel are available. Read-only.
AskToUpdateLinks	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.
Assistance	Returns an IAssistance object for Microsoft Excel that represents the Microsoft Office Help Viewer. Read-only.
AutoCorrect	Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes. Read-only.
AutoFormatAsYouTypeReplaceHyperlinks	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.
AutomationSecurity	Returns or sets an MsoAutomationSecurity constant that represents the security mode Microsoft Excel uses when programmatically opening files. Read/write.
AutoPercentEntry	True if entries in cells formatted as percentages aren’t automatically multiplied by 100 as soon as they are entered. Read/write Boolean.
AutoRecover	Returns an AutoRecover object, which backs up all file formats on a timed interval.
Build	Returns the Microsoft Excel build number. Read-only Long.
CalculateBeforeSave	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.
Calculation	Returns or sets a XlCalculation value that represents the calculation mode.
CalculationInterruptKey	Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations. Read/write.
CalculationState	Returns an XlCalculationState constant that indicates the calculation state of the application, for any calculations that are being performed in Microsoft Excel. Read-only.
CalculationVersion	Returns a number whose rightmost four digits are the minor calculation engine version number, and whose other digits (on the left) are the major version of Microsoft Excel. Read-only Long.
Caller	Returns information about how Visual Basic was called (for more information, see the Remarks section).
CanPlaySounds	This property should not be used. Sound notes have been removed from Microsoft Excel.
CanRecordSounds	This property should not be used. Sound notes have been removed from Microsoft Excel.
Caption	Returns or sets a String value that represents the name that appears in the title bar of the main Microsoft Excel window.
CellDragAndDrop	True if dragging and dropping cells is enabled. Read/write Boolean.
Cells	Returns a Range object that represents all the cells on the active worksheet. If the active document is not a worksheet, this property fails.
ChartDataPointTrack	True will cause all charts in newly created documents to use the cell reference tracking behavior.Boolean
Charts	Returns a Sheets collection that represents all the chart sheets in the active workbook.
ClipboardFormats	Returns the formats that are currently on the Clipboard, as an array of numeric values. To determine whether a particular format is on the Clipboard, compare each element in the array with the appropriate constant listed in the Remarks section. Read-only Variant.
ClusterConnector	Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins. Read/write
Columns	Returns a Range object that represents all the columns on the active worksheet. If the active document isn't a worksheet, the Columns property fails.
COMAddIns	Returns the COMAddIns collection for Microsoft Excel, which represents the currently installed COM add-ins. Read-only.
CommandBars	Returns a CommandBars object that represents the Microsoft Excel command bars. Read-only.
CommandUnderlines	Returns or sets the state of the command underlines in Microsoft Excel for the Macintosh. Can be one of the constants of XlCommandUnderlines. Read/write Long.
ConstrainNumeric	True if handwriting recognition is limited to numbers and punctuation only. Read/write Boolean.
ControlCharacters	True if Microsoft Excel displays control characters for right-to-left languages. Read/write Boolean.
CopyObjectsWithCells	True if objects are cut, copied, extracted, and sorted with cells. Read/write Boolean.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Cursor	Returns or sets the appearance of the mouse pointer in Microsoft Excel. Read/write XlMousePointer.
CursorMovement	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.
CustomListCount	Returns the number of defined custom lists (including built-in lists). Read-only Long.
CutCopyMode	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.
DataEntryMode	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.
DDEAppReturnCode	Returns the application-specific DDE return code that was contained in the last DDE acknowledge message received by Microsoft Excel. Read-only Long.
DecimalSeparator	Sets or returns the character used for the decimal separator as a String. Read/write.
DefaultFilePath	Returns or sets the default path that Microsoft Excel uses when it opens files. Read/write String.
DefaultSaveFormat	Returns or sets the default format for saving files. For a list of valid constants, see the FileFormat property. Read/write Long.
DefaultSheetDirection	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.
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.
DeferAsyncQueries	Gets or sets whether asychronous queries to OLAP data sources are executed when a worksheet is calculated by VBA code. Read/write Boolean.
Dialogs	Returns a Dialogs collection that represents all built-in dialog boxes. Read-only.
DisplayAlerts	True if Microsoft Excel displays certain alerts and messages while a macro is running. Read/write Boolean.
DisplayClipboardWindow	Returns True if the Microsoft Office Clipboard can be displayed. Read/write Boolean.
DisplayCommentIndicator	Returns or sets the way cells display comments and indicators. Can be one of the XlCommentDisplayMode constants.
DisplayDocumentActionTaskPane	Set to True to display the Document Actions task pane; set to False to hide the Document Actions task pane. Read/write Boolean.
DisplayDocumentInformationPanel	Returns or sets a Boolean that represents whether the document properties panel is displayed. Read/write Boolean.
DisplayExcel4Menus	True if Microsoft Excel displays version 4.0 menu bars. Read/write Boolean.
DisplayFormulaAutoComplete	Gets or sets whether to show a list of relevant functions and defined names when building cell formulas. Read/write Boolean.
DisplayFormulaBar	True if the formula bar is displayed. Read/write Boolean.
DisplayFullScreen	True if Microsoft Excel is in full-screen mode. Read/write Boolean.
DisplayFunctionToolTips	True if function ToolTips can be displayed. Read/write Boolean.
DisplayInsertOptions	True if the Insert Options button should be displayed. Read/write Boolean.
DisplayNoteIndicator	True if cells containing notes display cell tips and contain note indicators (small dots in their upper-right corners). Read/write Boolean.
DisplayPasteOptions	True if the Paste Options button can be displayed. Read/write Boolean.
DisplayRecentFiles	True if the list of recently used files is displayed in the UI. Read/write Boolean.
DisplayScrollBars	True if scroll bars are visible for all workbooks. Read/write Boolean.
DisplayStatusBar	True if the status bar is displayed. Read/write Boolean.
EditDirectlyInCell	True if Microsoft Excel allows editing in cells. Read/write Boolean.
EnableAutoComplete	True if the AutoComplete feature is enabled. Read/write Boolean.
EnableCancelKey	Controls how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure. Read/write XlEnableCancelKey.
EnableCheckFileExtensions	True to enable the Tell me if Microsoft Excel isn't the default program for viewing and editing spreadsheets dialog box. Read/write Boolean.
EnableEvents	True if events are enabled for the specified object. Read/write Boolean.
EnableLargeOperationAlert	Sets or returns a Boolean that represents whether to display an alert message when a user attempts to perform an operation that affects a larger number of cells than is specified in the Office center UI. Read/write Boolean.
EnableLivePreview	Sets or returns a Boolean that represents whether to show or hide gallery previews that appear when using galleries that support previewing. Setting this property to True shows a preview of your workbook before applying the command. Read/write Boolean.
EnableMacroAnimations	Controls whether macro animations are enabled. True if user interface animations or chart animations are enabled. Is set to False (no animation) by default. If it is set to True during the running of a macro, it will enable animation and then will reset to False after the macro runs. Read/write Boolean.
EnableSound	True if sound is enabled for Microsoft Office. Read/write Boolean.
ErrorCheckingOptions	Returns an ErrorCheckingOptions object, which represents the error checking options for an application.
Excel4IntlMacroSheets	Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. Read-only.
Excel4MacroSheets	Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. Read-only.
ExtendList	True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list. Read/write Boolean.
FeatureInstall	Returns or sets a value (constant) that specifies how Microsoft Excel handles calls to methods and properties that require features that aren’t yet installed. Can be one of the MsoFeatureInstall constants listed in the following table. Read/write MsoFeatureInstall.
FileConverters	Returns information about installed file converters. Returns null if there are no converters installed. Read-only Variant.
FileDialog	Returns a FileDialog object representing an instance of the file dialog.
FileExportConverters	Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.
FileValidation	Returns or sets how Excel will validate files before opening them. Read/write
FileValidationPivot	Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write
FindFormat	Sets or returns the search criteria for the type of cell formats to find.
FixedDecimal	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.
FixedDecimalPlaces	Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True. Read/write Long.
FlashFill	TRUE indicates that the Excel Flash Fill feature has been enabled and active. Boolean Read/Write
FlashFillMode	True if the Flash Fill feature is enabled. Boolean Read/Write
FormulaBarHeight	Allows the user to specify the height of the formula bar in lines. Read/write Long.
GenerateGetPivotData	Returns True when Microsoft Excel can get PivotTable report data. Read/write Boolean.
GenerateTableRefs	The GenerateTableRefs property determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas. Read/write.
Height	Returns or sets a Double value that represents tThe height, in points, of the main application window.
HighQualityModeForGraphics	Returns or sets whether Excel uses high quality mode to print graphics. Read/write
Hinstance	Returns a handle to the instance of Microsoft Excel 2013 represented by the Application object. Read-only Long.
HinstancePtr	Returns a handle to the instance of Microsoft Excel 2013 represented by the specified Application object. Read-only Variant.
Hwnd	Returns a Long indicating the top-level window handle of the Microsoft Excel window. Read-only.
IgnoreRemoteRequests	True if remote DDE requests are ignored. Read/write Boolean.
Interactive	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). Read/write Boolean.
International	Returns information about the current country/region and international settings. Read-only Variant.
IsSandboxed	Returns True if the specified workbook is open in a Protected View window. Read-only
Iteration	True if Microsoft Excel will use iteration to resolve circular references. Read/write Boolean.
LanguageSettings	Returns the LanguageSettings object, which contains information about the language settings in Microsoft Excel. Read-only.
LargeOperationCellThousandCount	Returns or sets the maximum number of cells needed in an operation beyond which an alert is triggered. Read/write Long.
Left	Returns or sets a Double value that represents the distance, in points, from the left edge of the screen to the left edge of the main Microsoft Excel window.
LibraryPath	Returns the path to the Library folder, but without the final separator. Read-only String.
MailSession	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.
MailSystem	Returns the mail system that's installed on the host machine. Read-only XlMailSystem.
MapPaperSize	True if documents formatted for the standard paper size of another country/region (for example, A4) are automatically adjusted so that they're printed correctly on the standard paper size (for example, Letter) of your country/region. Read/write Boolean.
MathCoprocessorAvailable	True if a math coprocessor is available. Read-only Boolean.
MaxChange	Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references. Read/write Double.
MaxIterations	Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference. Read/write Long.
MeasurementUnit	Specifies the measurement unit used in the application. Read/write xlMeasurementUnit.
MergeInstances	True to merge multiple instances of the application into a single instance. Read/Write Boolean.
MouseAvailable	True if a mouse is available. Read-only Boolean.
MoveAfterReturn	True if the active cell will be moved as soon as the ENTER (RETURN) key is pressed. Read/write Boolean.
MoveAfterReturnDirection	Returns or sets the direction in which the active cell is moved when the user presses ENTER. Read/write XlDirection.
MultiThreadedCalculation	Returns a MultiThreadedCalculation object that controls the multi-threaded recalculation settings. Read-only.
Name	Returns a String value that represents the name of the object.
Names	Returns a Names collection that represents all the names in the active workbook. Read-only Names object.
NetworkTemplatesPath	Returns the network path where templates are stored. If the network path doesn’t exist, this property returns an empty string. Read-only String.
NewWorkbook	Returns a NewFile object.
ODBCErrors	Returns an ODBCErrors collection that contains all the ODBC errors generated by the most recent query table or PivotTable report operation. Read-only.
ODBCTimeout	Returns or sets the ODBC query time limit, in seconds. The default value is 45 seconds. Read/write Long.
OLEDBErrors	Returns the OLEDBErrors collection, which represents the error information returned by the most recent OLE DB query. Read-only.
OnWindow	Returns or sets the name of the procedure that’s run whenever you activate a window. Read/write String.
OperatingSystem	Returns the name and version number of the current operating system — for example, "Windows (32-bit) 4.00" or "Macintosh 7.00". Read-only String.
OrganizationName	Returns the registered organization name. Read-only String.
Parent	Returns the parent object for the specified object. Read-only.
Path	Returns a String value that represents the complete path to the application, excluding the final separator and name of the application.
PathSeparator	Returns the path separator character ("\"). Read-only String.
PivotTableSelection	True if PivotTable reports use structured selection. Read/write Boolean.
PreviousSelections	Returns an array of the last four ranges or names selected. Each element in the array is a Range object. Read-only Variant.
PrintCommunication	Specifies whether communication with the printer is turned on. Boolean Read/write
ProductCode	Returns the globally unique identifier (GUID) for Microsoft Excel. Read-only String.
PromptForSummaryInfo	True if Microsoft Excel asks for summary information when files are first saved. Read/write Boolean.
ProtectedViewWindows	Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Read-only
QuickAnalysis	Returns a QuickAnalysis object that represents the Quick Analysis options of the application.
Range	Returns a Range object that represents a cell or a range of cells.
Ready	Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready. Read-only Boolean.
RecentFiles	Returns a RecentFiles collection that represents the list of recently used files.
RecordRelative	True if macros are recorded using relative references; False if recording is absolute. Read-only Boolean.
ReferenceStyle	Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.
RegisteredFunctions	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.
ReplaceFormat	Sets the replacement criteria to use in replacing cell formats. The replacement criteria is then used in a subsequent call to the Replace method of the Range object.
RollZoom	True if the IntelliMouse zooms instead of scrolling. Read/write Boolean.
Rows	Returns a Range object that represents all the rows on the active worksheet. If the active document isn’t a worksheet, the Rows property fails. Read-only Range object.
RTD	Returns an RTD object.
ScreenUpdating	True if screen updating is turned on. Read/write Boolean.
Selection	Returns the selected object in the active window for an Application object.
Sheets	Returns a Sheets collection that represents all the sheets in the active workbook. Read-only Sheets object.
SheetsInNewWorkbook	Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks. Read/write Long.
ShowChartTipNames	True if charts show chart tip names. The default value is True. Read/write Boolean.
ShowChartTipValues	True if charts show chart tip values. The default value is True. Read/write Boolean.
ShowDevTools	Returns or sets a Boolean that represents whether the Developer tab is displayed in the ribbon. Read/write Boolean.
ShowMenuFloaties	Returns or sets a Boolean that represents whether to display Mini toolbars when the user right-clicks in the workbook window. False if Mini toolbars are displayed. Read/write Boolean.
ShowQuickAnalysis	Controls whether the Quick Analysis contextual user interface is displayed on selection. TRUE means the Quick Analysis button will show. Corresponds to the Show Quick Analysis options on selection checkbox located in the File menu, Options, Excel Options, and then General tab. Read/Write. Boolean.
ShowSelectionFloaties	Returns or sets a Boolean that represents whether Mini toolbars displays when a user selects text. False if Mini toolbars are displayed. Read/write Boolean.
ShowStartupDialog	Returns True (default is False) when the New Workbook task pane appears for a Microsoft Excel application. Read/write Boolean.
ShowToolTips	True if ToolTips are turned on. Read/write Boolean.
SmartArtColors	Returns the set of color styles that are currently loaded in the application. Read-only
SmartArtLayouts	Returns the set of SmartArt layouts that are currently loaded in the application. Read-only
SmartArtQuickStyles	Returns the set of SmartArt quick styles which are currently loaded in the application. Read-only
Speech	Returns a Speech object.
SpellingOptions	Returns a SpellingOptions object that represents the spelling options of the application.
StandardFont	Returns or sets the name of the standard font. Read/write String.
StandardFontSize	Returns or sets the standard font size, in points. Read/write Long.
StartupPath	Returns the complete path of the startup folder, excluding the final separator. Read-only String.
StatusBar	Returns or sets the text in the status bar. Read/write String.
TemplatesPath	Returns the local path where templates are stored. Read-only String.
ThisCell	Returns the cell in which the user-defined function is being called from as a Range object.
ThisWorkbook	Returns a Workbook object that represents the workbook where the current macro code is running. Read-only.
ThousandsSeparator	Sets or returns the character used for the thousands separator as a String. Read/write.
Top	Returns or sets a Double value that represents the distance, in points, from the top edge of the screen to the top edge of the main Microsoft Excel window.
TransitionMenuKey	Returns or sets the Microsoft Excel menu or help key, which is usually "/". Read/write String.
TransitionMenuKeyAction	Returns or sets the action taken when the Microsoft Excel menu key is pressed. Can be either xlExcelMenus or xlLotusHelp. Read/write Long.
TransitionNavigKeys	True if transition navigation keys are active. Read/write Boolean.
UsableHeight	Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double.
UsableWidth	Returns the maximum width of the space that a window can occupy in the application window area, in points. Read-only Double.
UseClusterConnector	Returns or sets whether Excel allows user-defined functions in XLL add-ins to be run on a compute cluster. Read/write
UsedObjects	Returns a UsedObjects object representing objects allocated in a workbook. Read-only
UserControl	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.
UserLibraryPath	Returns the path to the location on the user’s computer where the COM add-ins are installed. Read-only String.
UserName	Returns or sets the name of the current user. Read/write String.
UseSystemSeparators	True (default) if the system separators of Microsoft Excel are enabled. Read/write Boolean.
Value	Returns a String value that represents the name of the application.
VBE	Returns a VBE object that represents the Visual Basic Editor. Read-only.
Version	Returns a String value that represents the Microsoft Excel version number.
Visible	Returns or sets a Boolean value that determines whether the object is visible. Read/write.
WarnOnFunctionNameConflict	The WarnOnFunctionNameConflict property, when set to True, raises an alert if a developer tries to create a new function using an existing function name. Read/write Boolean.
Watches	Returns a Watches object representing a range which is tracked when the worksheet is recalculated.
Width	Returns or sets a Double value that represents the distance, in points, from the left edge of the application window to its right edge.
Windows	Returns a Windows collection that represents all the windows in all the workbooks. Read-only Windows object.
WindowsForPens	True if the computer is running under Microsoft Windows for Pen Computing. Read-only Boolean.
WindowState	Returns or sets the state of the window. Read/write XlWindowState.
Workbooks	Returns a Workbooks collection that represents all the open workbooks. Read-only.
WorksheetFunction	Returns the WorksheetFunction object. Read-only.
Worksheets	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.
EnableAnimations	This object, member, or enumeration is deprecated and is not intended to be used in your code.

Application Properties (Excel)

Properties

Additional resources