Export (0) Print
Expand All

Workbook Object Members

Office 2007

Represents a Microsoft Excel workbook.

Methods

 NameDescription
Bb225767.methods(en-us,office.12).gif AcceptAllChanges Accepts all changes in the specified shared workbook.
Bb225767.methods(en-us,office.12).gif Activate Activates the first window associated with the workbook.
Bb225767.methods(en-us,office.12).gif AddToFavorites Adds a shortcut to the workbook or hyperlink to the Favorites folder.
Bb225767.methods(en-us,office.12).gif ApplyTheme Applies the specified theme to the current workbook.
Bb225767.methods(en-us,office.12).gif BreakLink Converts formulas linked to other Microsoft Excel sources or OLE sources to values.
Bb225767.methods(en-us,office.12).gif CanCheckIn True if Microsoft Excel can check in a specified workbook to a server. Read/write Boolean.
Bb225767.methods(en-us,office.12).gif ChangeFileAccess Changes the access permissions for the workbook. This may require an updated version to be loaded from the disk.
Bb225767.methods(en-us,office.12).gif ChangeLink Changes a link from one document to another.
Bb225767.methods(en-us,office.12).gif CheckIn Returns a workbook from a local computer to a server, and sets the local workbook to read-only so that it cannot be edited locally. Calling this method will also close the workbook.
Bb225767.methods(en-us,office.12).gif Close Closes the object.
Bb225767.methods(en-us,office.12).gif DeleteNumberFormat Deletes a custom number format from the workbook.
Bb225767.methods(en-us,office.12).gif EnableConnections The EnableConnections method allows developers to programmatically enable data connections within the workbook for the user.
Bb225767.methods(en-us,office.12).gif EndReview Terminates a review of a file that has been sent for review using the SendForReview method.
Bb225767.methods(en-us,office.12).gif ExclusiveAccess Assigns the current user exclusive access to the workbook that's open as a shared list.
Bb225767.methods(en-us,office.12).gif ExportAsFixedFormat The ExportAsFixedFormat method is used to publish a workbook to either the PDF or XPS format.
Bb225767.methods(en-us,office.12).gif FollowHyperlink Displays a cached document, if it’s already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application.
Bb225767.methods(en-us,office.12).gif ForwardMailer 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.
Bb225767.methods(en-us,office.12).gif GetWorkflowTasks Returns the collection of WorkflowTask objects for the specified workbook.
Bb225767.methods(en-us,office.12).gif GetWorkflowTemplates Returns the collection of WorkflowTemplate objects for the specified workbook.
Bb225767.methods(en-us,office.12).gif HighlightChangesOptions Controls how changes are shown in a shared workbook.
Bb225767.methods(en-us,office.12).gif LinkInfo Returns the link date and update status.
Bb225767.methods(en-us,office.12).gif LinkSources Returns an array of links in the workbook. The names in the array are the names of the linked documents, editions, or DDE or OLE servers. Returns Empty if there are no links.
Bb225767.methods(en-us,office.12).gif LockServerFile Locks the workbook on the server to prevent modification.
Bb225767.methods(en-us,office.12).gif MergeWorkbook Merges changes from one workbook into an open workbook.
Bb225767.methods(en-us,office.12).gif NewWindow Creates a new window or a copy of the specified window.
Bb225767.methods(en-us,office.12).gif OpenLinks Opens the supporting documents for a link or links.
Bb225767.methods(en-us,office.12).gif PivotCaches Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only.
Bb225767.methods(en-us,office.12).gif Post Posts the specified workbook to a public folder. This method works only with a Microsoft Exchange client connected to a Microsoft Exchange server.
Bb225767.methods(en-us,office.12).gif PrintOut Prints the object.
Bb225767.methods(en-us,office.12).gif PrintPreview Shows a preview of the object as it would look when printed.
Bb225767.methods(en-us,office.12).gif Protect Protects a workbook so that it cannot be modified.
Bb225767.methods(en-us,office.12).gif ProtectSharing Saves the workbook and protects it for sharing.
Bb225767.methods(en-us,office.12).gif PurgeChangeHistoryNow Removes entries from the change log for the specified workbook.
Bb225767.methods(en-us,office.12).gif RecheckSmartTags Causes a foreground smart tag check to occur automatically annotating data that was not annotated before.
Bb225767.methods(en-us,office.12).gif RefreshAll Refreshes all external data ranges and PivotTable reports in the specified workbook.
Bb225767.methods(en-us,office.12).gif RejectAllChanges Rejects all changes in the specified shared workbook.
Bb225767.methods(en-us,office.12).gif ReloadAs Reloads a workbook based on an HTML document, using the specified document encoding.
Bb225767.methods(en-us,office.12).gif RemoveDocumentInformation Removes all information of the specified type from the workbook.
Bb225767.methods(en-us,office.12).gif RemoveUser Disconnects the specified user from the shared workbook.
Bb225767.methods(en-us,office.12).gif Reply 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.
Bb225767.methods(en-us,office.12).gif ReplyAll 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.
Bb225767.methods(en-us,office.12).gif ReplyWithChanges Sends an e-mail message to the author of a workbook that has been sent out for review, notifying them that a reviewer has completed review of the workbook.
Bb225767.methods(en-us,office.12).gif ResetColors Resets the color palette to the default colors.
Bb225767.methods(en-us,office.12).gif RunAutoMacros Runs the Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro attached to the workbook. This method is included for backward compatibility. For new Visual Basic code, you should use the Open, Close, Activate and Deactivate events instead of these macros.
Bb225767.methods(en-us,office.12).gif Save Saves changes to the specified workbook.
Bb225767.methods(en-us,office.12).gif SaveAs Saves changes to the workbook in a different file.
Bb225767.methods(en-us,office.12).gif SaveAsXMLData Exports the data that has been mapped to the specified XML schema map to an XML data file.
Bb225767.methods(en-us,office.12).gif SaveCopyAs Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.
Bb225767.methods(en-us,office.12).gif SendFaxOverInternet Sends a worksheet as a fax to the specfied recipients.
Bb225767.methods(en-us,office.12).gif SendForReview Sends a workbook in an e-mail message for review to the specified recipients.
Bb225767.methods(en-us,office.12).gif SendMail Sends the workbook by using the installed mail system.
Bb225767.methods(en-us,office.12).gif SendMailer 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.
Bb225767.methods(en-us,office.12).gif SetLinkOnData Sets the name of a procedure that runs whenever a DDE link is updated.
Bb225767.methods(en-us,office.12).gif SetPasswordEncryptionOptions Sets the options for encrypting workbooks using passwords.
Bb225767.methods(en-us,office.12).gif ToggleFormsDesign The ToggleFormsDesign method is used to toggle short_Excel2007 into Design Mode when using forms controls.
Bb225767.methods(en-us,office.12).gif Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
Bb225767.methods(en-us,office.12).gif UnprotectSharing Turns off protection for sharing and saves the workbook.
Bb225767.methods(en-us,office.12).gif UpdateFromFile Updates a read-only workbook from the saved disk version of the workbook if the disk version is more recent than the copy of the workbook that is loaded in memory. If the disk copy hasn't changed since the workbook was loaded, the in-memory copy of the workbook isn't reloaded.
Bb225767.methods(en-us,office.12).gif UpdateLink Updates a Microsoft Excel, DDE, or OLE link (or links).
Bb225767.methods(en-us,office.12).gif WebPagePreview Displays a preview of the specified workbook as it would look if saved as a Web page.
Bb225767.methods(en-us,office.12).gif XmlImport Imports an XML data file into the current workbook.
Bb225767.methods(en-us,office.12).gif XmlImportXml Imports an XML data stream that has been previously loaded into memory. Excel uses the first qualifying map found or if the destination range is specified, Excel will automatically list the data.

Properties

 NameDescription
Bb225767.properties(en-us,office.12).gif 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.
Bb225767.properties(en-us,office.12).gif 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.
Bb225767.properties(en-us,office.12).gif 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.
Bb225767.properties(en-us,office.12).gif AutoUpdateFrequency Returns or sets the number of minutes between automatic updates to the shared workbook. Read/write Long.
Bb225767.properties(en-us,office.12).gif AutoUpdateSaveChanges True if current changes to the shared workbook are posted to other users whenever the workbook is automatically updated. False if changes aren’t posted (this workbook is still synchronized with changes made by other users). The default value is True. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif BuiltinDocumentProperties Returns a DocumentProperties collection that represents all the built-in document properties for the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif CalculationVersion Returns the information about the version of Excel that the workbook was last fully recalculated by. Read-only Long.
Bb225767.properties(en-us,office.12).gif ChangeHistoryDuration Returns or sets the number of days shown in the shared workbook's change history. Read/write Long.
Bb225767.properties(en-us,office.12).gif Charts Returns a Sheets collection that represents all the chart sheets in the specified workbook.
Bb225767.properties(en-us,office.12).gif CheckCompatibility Controls whether or not the compatibility checker is run automatically when the workbook is saved. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif CodeName Returns the code name for the object. Read-only String.
Bb225767.properties(en-us,office.12).gif Colors Returns or sets colors in the palette for the workbook. The palette has 56 entries, each represented by an RGB value. Read/write Variant.
Bb225767.properties(en-us,office.12).gif CommandBars Returns a CommandBars object that represents the Microsoft Excel command bars. Read-only.
Bb225767.properties(en-us,office.12).gif ConflictResolution Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated. Read/write XlSaveConflictResolution.
Bb225767.properties(en-us,office.12).gif Connections The Connections property establishes a connection between the workbook and an ODBC or an OLEDB data source and refreshes the data without prompting the user. Read-only.
Bb225767.properties(en-us,office.12).gif ConnectionsDisabled Disables the external connections or links in the workbook. Read-only
Bb225767.properties(en-us,office.12).gif Container Returns the object that represents the container application for the specified OLE object. Read-only Object.
Bb225767.properties(en-us,office.12).gif ContentTypeProperties Returns a MetaProperties collection that describes the metadata stored in the workbook. Read-only.
Bb225767.properties(en-us,office.12).gif CreateBackup True if a backup file is created when this file is saved. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb225767.properties(en-us,office.12).gif CustomDocumentProperties Returns or sets a DocumentProperties collection that represents all the custom document properties for the specified workbook.
Bb225767.properties(en-us,office.12).gif CustomViews Returns a CustomViews collection that represents all the custom views for the workbook.
Bb225767.properties(en-us,office.12).gif CustomXMLParts Returns a CustomXMLParts collection that represents the custom XML in the XML data store. Read-only.
Bb225767.properties(en-us,office.12).gif Date1904 True if the workbook uses the 1904 date system. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif DefaultPivotTableStyle Specifies the table style from the TableStyles collection that is used as the default style for PivotTables. Read/write.
Bb225767.properties(en-us,office.12).gif DefaultTableStyle Specifies the table style from the TableStyles collection that is used as the default TableStyle. Read/write Variant.
Bb225767.properties(en-us,office.12).gif DisplayDrawingObjects Returns or sets how shapes are displayed. Read/write Long.
Bb225767.properties(en-us,office.12).gif DisplayInkComments A Boolean value that determines whether ink comments are displayed in the workbook. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif DocumentInspectors Returns a DocumentInspectors collection that represents the Document Inspector modules for the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif DocumentLibraryVersions Returns a DocumentLibraryVersions collection that represents the collection of versions of a shared workbook that has versioning enabled and that is stored in a document library on a server.
Bb225767.properties(en-us,office.12).gif DoNotPromptForConvert Returns or sets if the user should be prompted to convert the workbook if the workbook contains features that are not supported by versions of Excel earlier than short_Excel2007. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif EnableAutoRecover Saves changed files, of all formats, on a timed interval. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif EncryptionProvider Returns a String specifying the name of the algorithm encryption provider that 1st_Excel12 uses when encrypting documents. Read/write.
Bb225767.properties(en-us,office.12).gif EnvelopeVisible True if the e-mail composition header and the envelope toolbar are both visible. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif Excel4IntlMacroSheets Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif Excel4MacroSheets Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif Excel8CompatibilityMode The Excel8CompatibilityMode property provides developers with a way to check if the workbook is in compatibility mode. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif FileFormat Returns the file format and/or type of the workbook. Read-only XlFileFormat.
Bb225767.properties(en-us,office.12).gif Final Returns or sets a Boolean that indicates whether a workbook is final. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif ForceFullCalculation Forces a full calculation of a workbook. Read/write.
Bb225767.properties(en-us,office.12).gif FullName Returns the name of the object, including its path on disk, as a string. Read-only String.
Bb225767.properties(en-us,office.12).gif FullNameURLEncoded Returns a String indicating the name of the object, including its path on disk, as a string. Read-only.
Bb225767.properties(en-us,office.12).gif HasPassword True if the workbook has a protection password. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif HasVBProject Returns a Boolean that represents whether a workbook has an attached Microsoft Visual Basic for Applications project. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif HighlightChangesOnScreen True if changes to the shared workbook are highlighted on-screen. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif IconSets This property is used to filter data in a workbook based on a cell icon from the IconSet collection. Read-only.
Bb225767.properties(en-us,office.12).gif InactiveListBorderVisible A Boolean value that specifies whether list borders are visible when a list is not active. Returns True if the border is visible. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif IsAddin True if the workbook is running as an add-in. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif IsInplace True if the specified workbook is being edited in place. False if the workbook has been opened in Microsoft Excel for editing. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif KeepChangeHistory True if change tracking is enabled for the shared workbook. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif ListChangesOnNewSheet True if changes to the shared workbook are shown on a separate worksheet. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif Mailer 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.
Bb225767.properties(en-us,office.12).gif MultiUserEditing True if the workbook is open as a shared list. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb225767.properties(en-us,office.12).gif Names Returns a Names collection that represents all the names in the specified workbook (including all worksheet-specific names). Read-only Names object.
Bb225767.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225767.properties(en-us,office.12).gif Password Returns or sets the password that must be supplied to open the specified workbook. Read/write String.
Bb225767.properties(en-us,office.12).gif PasswordEncryptionAlgorithm Returns a String indicating the algorithm Microsoft Excel uses to encrypt passwords for the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif PasswordEncryptionFileProperties True if Microsoft Excel encrypts file properties for the specified password-protected workbook. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif PasswordEncryptionKeyLength Returns a Long indicating the key length of the algorithm Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif PasswordEncryptionProvider Returns a String specifying the name of the algorithm encryption provider that Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif Path Returns a String that represents the complete path to the workbook/file that this workbook object respresents.
Bb225767.properties(en-us,office.12).gif Permission Returns a Permission object that represents the permission settings in the specified workbook.
Bb225767.properties(en-us,office.12).gif PersonalViewListSettings True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif PersonalViewPrintSettings True if print settings are included in the user's personal view of the shared workbook. Read-write Boolean.
Bb225767.properties(en-us,office.12).gif PrecisionAsDisplayed True if calculations in this workbook will be done using only the precision of the numbers as they’re displayed. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif ProtectStructure True if the order of the sheets in the workbook is protected. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif ProtectWindows True if the windows of the workbook are protected. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif PublishObjects Returns the PublishObjects collection. Read-only.
Bb225767.properties(en-us,office.12).gif ReadOnly Returns True if the object has been opened as read-only. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif ReadOnlyRecommended True if the workbook was saved as read-only recommended. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif RemovePersonalInformation True if personal information can be removed from the specified workbook. The default value is False. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif Research Returns a Research object that represents the research service for a workbook. Read-only.
Bb225767.properties(en-us,office.12).gif RevisionNumber Returns the number of times the workbook has been saved while open as a shared list. If the workbook is open in exclusive mode, this property returns 0 (zero). Read-only Long.
Bb225767.properties(en-us,office.12).gif Saved True if no changes have been made to the specified workbook since it was last saved. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif SaveLinkValues True if Microsoft Excel saves external link values with the workbook. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif ServerPolicy Returns a ServerPolicy object that represents a policy specified for a workbook stored on a server running 2nd_OSS_NoVersion 2007. Read-only.
Bb225767.properties(en-us,office.12).gif ServerViewableItems Allows a developer to interact with the list of published objects in the workbook that are shown on the server. Read-only.
Bb225767.properties(en-us,office.12).gif SharedWorkspace Returns a SharedWorkspace object that represents the Document Workspace in which a specified document is located. Read-only.
Bb225767.properties(en-us,office.12).gif Sheets Returns a Sheets collection that represents all the sheets in the specified workbook. Read-only Sheets object.
Bb225767.properties(en-us,office.12).gif ShowConflictHistory True if the Conflict History worksheet is visible in the workbook that's open as a shared list. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif ShowPivotChartActiveFields This property controls the visibility of the PivotChart Filter Pane. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif ShowPivotTableFieldList True (default) if the PivotTable field list can be shown. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif Signatures Returns the digital signatures for a workbook. Read-only.
Bb225767.properties(en-us,office.12).gif SmartDocument Returns a SmartDocument object that represents the settings for a smart document solution. Read-only.
Bb225767.properties(en-us,office.12).gif SmartTagOptions Returns a SmartTagOptions object representing the options that can be performed with a smart tag.
Bb225767.properties(en-us,office.12).gif Styles Returns a Styles collection that represents all the styles in the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif Sync Returns a Sync object that provides access to the methods and properties for documents that are part of a Document Workspace.
Bb225767.properties(en-us,office.12).gif TableStyles Returns a TableStyles collection object for the current workbook that refers to the styles used in the current workbook. Read-only.
Bb225767.properties(en-us,office.12).gif TemplateRemoveExtData True if external data references are removed when the workbook is saved as a template. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif Theme Returns the theme applied to the current workbook. Read-only.
Bb225767.properties(en-us,office.12).gif UpdateLinks Returns or sets an XlUpdateLink constant indicating a workbook's setting for updating embedded OLE links. Read/write.
Bb225767.properties(en-us,office.12).gif UpdateRemoteReferences True if Microsoft Excel updates remote references in for the workbook. Read/write Boolean.
Bb225767.properties(en-us,office.12).gif UserStatus Returns a 1-based, two-dimensional array that provides information about each user who has the workbook open as a shared list. Read-only Variant.
Bb225767.properties(en-us,office.12).gif VBASigned True if the Visual Basic for Applications project for the specified workbook has been digitally signed. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif VBProject Returns a VBProject object that represents the Visual Basic project in the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif WebOptions Returns the WebOptions collection, which contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. Read-only.
Bb225767.properties(en-us,office.12).gif Windows Returns a Windows collection that represents all the windows in the specified workbook. Read-only Windows object.
Bb225767.properties(en-us,office.12).gif Worksheets Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.
Bb225767.properties(en-us,office.12).gif WritePassword Returns or sets a String for the write password of a workbook. Read/write.
Bb225767.properties(en-us,office.12).gif WriteReserved True if the workbook is write-reserved. Read-only Boolean.
Bb225767.properties(en-us,office.12).gif WriteReservedBy Returns the name of the user who currently has write permission for the workbook. Read-only String.
Bb225767.properties(en-us,office.12).gif XmlMaps Returns an XmlMaps collection that represents the schema maps that have been added to the specified workbook. Read-only.
Bb225767.properties(en-us,office.12).gif XmlNamespaces Returns an XmlNamespaces collection that represents the XML namespaces contained in the specified workbook. Read-only.

Events

 NameDescription
Bb225767.events(en-us,office.12).gif Activate Occurs when a workbook, worksheet, chart sheet, or embedded chart is activated.
Bb225767.events(en-us,office.12).gif AddinInstall Occurs when the workbook is installed as an add-in
Bb225767.events(en-us,office.12).gif AddinUninstall Occurs when the workbook is uninstalled as an add-in.
Bb225767.events(en-us,office.12).gif AfterXmlExport Occurs after Microsoft Excel saves or exports XML data from the specified workbook.
Bb225767.events(en-us,office.12).gif AfterXmlImport Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
Bb225767.events(en-us,office.12).gif BeforeClose Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
Bb225767.events(en-us,office.12).gif BeforePrint Occurs before the workbook (or anything in it) is printed.
Bb225767.events(en-us,office.12).gif BeforeSave Occurs before the workbook is saved.
Bb225767.events(en-us,office.12).gif BeforeXmlExport Occurs before Microsoft Excel saves or exports XML data from the specified workbook.
Bb225767.events(en-us,office.12).gif BeforeXmlImport Occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
Bb225767.events(en-us,office.12).gif Deactivate Occurs when the chart, worksheet, or workbook is deactivated.
Bb225767.events(en-us,office.12).gif NewSheet Occurs when a new sheet is created in the workbook.
Bb225767.events(en-us,office.12).gif Open Occurs when the workbook is opened.
Bb225767.events(en-us,office.12).gif PivotTableCloseConnection Occurs after a PivotTable report closes the connection to its data source.
Bb225767.events(en-us,office.12).gif PivotTableOpenConnection Occurs after a PivotTable report opens the connection to its data source.
Bb225767.events(en-us,office.12).gif RowsetComplete The event is raised when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
Bb225767.events(en-us,office.12).gif SheetActivate Occurs when any sheet is activated.
Bb225767.events(en-us,office.12).gif SheetBeforeDoubleClick Occurs when any worksheet is double-clicked, before the default double-click action.
Bb225767.events(en-us,office.12).gif SheetBeforeRightClick Occurs when any worksheet is right-clicked, before the default right-click action.
Bb225767.events(en-us,office.12).gif SheetCalculate Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
Bb225767.events(en-us,office.12).gif SheetChange Occurs when cells in any worksheet are changed by the user or by an external link.
Bb225767.events(en-us,office.12).gif SheetDeactivate Occurs when any sheet is deactivated.
Bb225767.events(en-us,office.12).gif SheetFollowHyperlink Occurs when you click any hyperlink in Microsoft Excel. For worksheet-level events, see the Help topic for the FollowHyperlink event.
Bb225767.events(en-us,office.12).gif SheetPivotTableUpdate Occurs after the sheet of the PivotTable report has been updated.
Bb225767.events(en-us,office.12).gif SheetSelectionChange Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
Bb225767.events(en-us,office.12).gif Sync Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.
Bb225767.events(en-us,office.12).gif WindowActivate Occurs when any workbook window is activated.
Bb225767.events(en-us,office.12).gif WindowDeactivate Occurs when any workbook window is deactivated.
Bb225767.events(en-us,office.12).gif WindowResize Occurs when any workbook window is resized.


Show:
© 2014 Microsoft