Application Object Members

  • Article
Excel Developer Reference

Represents the entire Microsoft Excel application.

Methods

  Name Description
ActivateMicrosoftApp 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.
AddCustomList Adds a custom list for custom autofill and/or custom sort.
Calculate 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.
CalculateFull Forces a full calculation of the data in all open workbooks.
CalculateFullRebuild For all open workbooks, forces a full calculation of the data and rebuilds the dependencies.
CalculateUntilAsyncQueriesDone Runs all pending queries to OLEDB and OLAP data sources.
CentimetersToPoints Converts a measurement from centimeters to points (one point equals 0.035 centimeters).
CheckAbort Stops recalculation in a Microsoft Excel application.
CheckSpelling Checks the spelling of a single word.
ConvertFormula Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both. Variant.
DDEExecute Runs a command or performs some other action or actions in another application by way of the specified DDE channel.
DDEInitiate Opens a DDE channel to an application.
DDEPoke Sends data to an application.
DDERequest Requests information from the specified application. This method always returns an array.
DDETerminate Closes a channel to another application.
DeleteCustomList Deletes a custom list.
DisplayXMLSourcePane Opens the XML Source task pane and displays the XML map specified by the XmlMap argument.
DoubleClick Equivalent to double-clicking the active cell.
Evaluate Converts a Microsoft Excel name to an object or a value.
ExecuteExcel4Macro Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function.
FindFile Displays the Open dialog box.
GetCustomListContents Returns a custom list (an array of strings).
GetCustomListNum 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.
GetOpenFilename Displays the standard Open dialog box and gets a file name from the user without actually opening any files.
GetPhonetic 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.
GetSaveAsFilename Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.
Goto Selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active.
Help Displays a Help topic.
InchesToPoints Converts a measurement from inches to points.
InputBox Displays a dialog box for user input. Returns the information entered in the dialog box.
Intersect Returns a Range object that represents the rectangular intersection of two or more ranges.
MacroOptions Corresponds to options in the Macro Options dialog box. You can also use this method to display a user defined function (UDF) in a built-in or new category within the Insert Function dialog box.
MailLogoff Closes a MAPI mail session established by Microsoft Excel.
MailLogon 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.
NextLetter You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.
OnKey Runs a specified procedure when a particular key or key combination is pressed.
OnRepeat 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.
OnTime 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).
OnUndo Sets the text of the Undo and the name of the procedure that’s run if you choose the Undo command (Edit menu) after running the procedure that sets this property.
Quit Quits Microsoft Excel.
RecordMacro Records code if the macro recorder is on.
RegisterXLL Loads an XLL code resource and automatically registers the functions and commands contained in the resource.
Repeat Repeats the last user-interface action.
Run Runs a macro or calls a function. This can be used to run a macro written in Visual Basic or the Microsoft Excel macro language, or to run a function in a DLL or XLL.
SaveWorkspace Saves the current workspace.
SendKeys Sends keystrokes to the active application.
SharePointVersion Sets the SharePoint version number.
Undo Cancels the last user-interface action.
Union Returns the union of two or more ranges.
Volatile 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.
Wait Pauses a running macro until a specified time. Returns True if the specified time has arrived.

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 Read-only
ActivePrinter Returns or sets the name of the active printer. Read/write String.
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 (Tools menu). 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.
AnswerWizard Returns the AnswerWizard object for Microsoft Excel. Read-only.
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 short_Excel2007 that represents the Microsoft Office Help Viewer. Read-only.
Assistant Returns an Assistant object for Microsoft Excel.
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 isn’t a worksheet, this property fails.
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.
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.
EnableAnimations True if animated insertion and deletion is enabled. 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.
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.
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.
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.
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.
Hinstance Returns the instance handle of the instance that is calling Microsoft Excel. Read-only Long.
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.
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.
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 that are new in short_Excel2007. 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.
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.
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. Read/write Boolean.
ShowSelectionFloaties Returns or sets a Boolean that represents whether Mini toolbars displays when a user selects text. 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.
ShowWindowsInTaskbar True if there’s a separate Windows taskbar button for each open workbook. The default value is True. Read/write Boolean.
SmartTagRecognizers Returns a SmartTagRecognizers collection for an application.
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.
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.

Events

  Name Description
AfterCalculate The AfterCalculate event occurs when all pending refresh activity (both synchronous and asynchronous) and all of the resultant calculation activities have been completed.
NewWorkbook Occurs when a new workbook is created.
SheetActivate Occurs when any sheet is activated.
SheetBeforeDoubleClick Occurs when any worksheet is double-clicked, before the default double-click action.
SheetBeforeRightClick Occurs when any worksheet is right-clicked, before the default right-click action.
SheetCalculate Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
SheetChange Occurs when cells in any worksheet are changed by the user or by an external link.
SheetDeactivate Occurs when any sheet is deactivated.
SheetFollowHyperlink Occurs when you click any hyperlink in Microsoft Excel. For worksheet-level events, see the Help topic for the FollowHyperlink event.
SheetPivotTableUpdate Occurs after the sheet of the PivotTable report has been updated.
SheetSelectionChange Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
WindowActivate Occurs when any workbook window is activated.
WindowDeactivate Occurs when any workbook window is deactivated.
WindowResize Occurs when any workbook window is resized.
WorkbookActivate Occurs when any workbook is activated.
WorkbookAddinInstall Occurs when a workbook is installed as an add-in.
WorkbookAddinUninstall Occurs when any add-in workbook is uninstalled.
WorkbookAfterXmlExport Occurs after Microsoft Excel saves or exports XML data from the specified workbook.
WorkbookAfterXmlImport Occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
WorkbookBeforeClose Occurs immediately before any open workbook closes.
WorkbookBeforePrint Occurs before any open workbook is printed.
WorkbookBeforeSave Occurs before any open workbook is saved.
WorkbookBeforeXmlExport Occurs before Microsoft Excel saves or exports XML data from the specified workbook.
WorkbookBeforeXmlImport Occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
WorkbookDeactivate Occurs when any open workbook is deactivated.
WorkbookNewSheet Occurs when a new sheet is created in any open workbook.
WorkbookOpen Occurs when a workbook is opened.
WorkbookPivotTableCloseConnection Occurs after a PivotTable report connection has been closed.
WorkbookPivotTableOpenConnection Occurs after a PivotTable report connection has been opened.
WorkbookRowsetComplete The WorkbookRowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
WorkbookSync Occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.