ActiveWorkbook.Author = "Jean Selva"
Events
Name Description
Activate Occurs when a workbook, worksheet,
chart sheet, or embedded chart is activated.
AddinInstall Occurs when the workbook is installed as an add-in
AddinUninstall Occurs when the workbook is
uninstalled as an add-in.
AfterSave Occurs after the workbook is saved.
AfterXmlExport Occurs after Microsoft Excel saves or exports XML data from the specified workbook.
AfterXmlImport Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
BeforeClose Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
BeforePrint Occurs before the workbook (or
anything in it) is printed.
BeforeSave Occurs before the workbook is saved.
BeforeXmlExport Occurs before Microsoft Excel saves or exports XML data from the specified workbook.
BeforeXmlImport Occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
Deactivate Occurs when the chart, worksheet, or
workbook is deactivated.
ModelChange Occurs after the Excel data model is changed.
NewChart Occurs when a new chart is created in
the workbook.
NewSheet Occurs when a new sheet is created in
the workbook.
Open Occurs when the workbook is opened.
PivotTableCloseConnection Occurs after a PivotTable report closes the connection to its data source.
PivotTableOpenConnection Occurs after a PivotTable report opens the connection to its data source.
RowsetComplete The event is raised when the user either drills through the recordset or invokes the rowset action on an OLAP
PivotTable.
SheetActivate Occurs when any sheet is activated.
SheetBeforeDelete
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.
SheetLensGalleryRenderComplete Occurs when a callout gallery’s icons (dynamic & static) have completed rendering for a worksheet.
SheetPivotTableAfterValueChange Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
SheetPivotTableBeforeAllocateChanges Occurs before changes are applied to a PivotTable.
SheetPivotTableBeforeCommitChanges Occurs before changes are committed against the OLAP data source for a PivotTable.
SheetPivotTableBeforeDiscardChanges Occurs before changes to a PivotTable are discarded.
SheetPivotTableChangeSync Occurs after changes to a PivotTable.
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).
SheetTableUpdate Occurs after the sheet table has been updated.
Sync This object or member has been
deprecated, but it remains part of the object model for backward
compatibility. You should not use it in new applications.
WindowActivate Occurs when any workbook window is activated.
WindowDeactivate Occurs when any workbook window is deactivated.
WindowResize Occurs when any workbook window is
resized.
Methods
Name Description
AcceptAllChanges Accepts all changes in the specified shared workbook.
Activate Activates the first window associated with the workbook.
AddToFavorites Adds a shortcut to the workbook or hyperlink to the Favorites folder.
ApplyTheme Applies the specified theme to the current workbook.
BreakLink Converts formulas linked to other Microsoft Excel sources or OLE sources to values.
CanCheckIn True if Microsoft Excel can check in a specified workbook to a server.
Read/writeBoolean.
ChangeFileAccess Changes the access permissions for the workbook. This may require an updated version to be loaded from the disk.
ChangeLink Changes a link from one document to another.
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.
CheckInWithVersion Saves a workbook to a server from a local computer, and sets the local workbook to
read-only so that it cannot be edited locally.
Close Closes the object.
DeleteNumberFormat Deletes a custom number format from the workbook.
EnableConnections The EnableConnections method allows developers to programmatically enable data connections within the workbook for the user.
EndReview Terminates a review of a file that has been sent for review using
the SendForReviewmethod.
ExclusiveAccess Assigns the current user exclusive access to the workbook that's open as a shared list.
ExportAsFixedFormat The ExportAsFixedFormat method is used to publish a workbook to either the PDF or XPS format.
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.
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.
GetWorkflowTasks Returns the collection
of WorkflowTask objects for the specified workbook.
GetWorkflowTemplates Returns the collection
of WorkflowTemplate objects for the specified workbook.
HighlightChangesOptions Controls how changes are shown in a shared workbook.
LinkInfo Returns the link date and update status.
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.
LockServerFile Locks the workbook on the server to prevent modification.
MergeWorkbook Merges changes from one workbook into an open workbook.
NewWindow Creates a new window or a copy of the specified window.
OpenLinks Opens the supporting documents for a link or links.
PivotCaches Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only.
Post Posts the specified workbook to a public
folder. This method works only with a Microsoft Exchange client connected to a Microsoft Exchange server.
PrintOut Prints the object.
PrintPreview Shows a preview of the object as it would look when printed.
Protect Protects a workbook so that it cannot be modified.
ProtectSharing Saves the workbook and protects it for sharing.
PurgeChangeHistoryNow Removes entries from the change log for the specified workbook.
RefreshAll Refreshes all external data ranges and PivotTable reports in the specified workbook.
RejectAllChanges Rejects all changes in the specified shared workbook.
RemoveDocumentInformation Removes all information of the specified type from the workbook.
RemoveUser Disconnects the specified user from the shared workbook.
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.
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.
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.
ResetColors Resets the color palette to the default colors.
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.
Save Saves changes to the specified workbook.
SaveAs Saves changes to the workbook in a
different file.
SaveAsXMLData Exports the data that has been mapped to the specified XML schema map to an XML data file.
SaveCopyAs Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.
SendFaxOverInternet Sends a worksheet as a fax to the specfied recipients.
SendForReview Sends a workbook in an e-mail message for review to the specified recipients.
SendMail Sends the workbook by using the installed mail system.
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.
SetPasswordEncryptionOptions Sets the options for encrypting workbooks using passwords.
ToggleFormsDesign The ToggleFormsDesign method is used to toggle Excel into Design Mode when using forms controls.
Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
UnprotectSharing Turns off protection for sharing and saves the workbook.
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.
UpdateLink Updates a Microsoft Excel, DDE, or OLE link (or links).
XmlImport Imports an XML data file into the current workbook.
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
Name Description
AccuracyVersion Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results. Read/write
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.
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.
ActiveSlicer Returns an object that represents the active slicer in the active workbook or in the specified workbook. Returns Nothing if no slicer is active. 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.
AutoUpdateFrequency Returns or sets the number of minutes between automatic updates to the shared workbook. Read/write Long.
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.
BuiltinDocumentProperties Returns a DocumentProperties collection that represents all the built-in document properties for the specified workbook. Read-only.
CalculationVersion Returns the information about the version of Excel that the workbook was last fully recalculated by. Read-only Long.
CaseSensitive True if the workbook distinguishes between upper and lower case when comparing content. Read-only Boolean
ChangeHistoryDuration Returns or sets the number of days shown in the shared workbook's change history.
Read/write Long.
ChartDataPointTrack True will cause all charts in the current document to track the actual data point to which it’s attached. False will revert back to tracking the index of the data
point.Boolean Read/Write
Charts Returns a Sheets collection that represents all the chart sheets in the specified workbook.
CheckCompatibility Controls whether or not the compatibility checker is run automatically when the workbook is saved. Read/write Boolean.
CodeName Returns the code name for the object. Read-only String.
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.
CommandBars Returns a CommandBars object that
represents the Microsoft Excel command bars.
Read-only.
ConflictResolution Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated.
Read/write XlSaveConflictResolution.
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.
ConnectionsDisabled Disables the external connections or links in the workbook. Read-only
Container Returns the object that represents the container application for the specified OLE object. Read-only Object.
ContentTypeProperties Returns a MetaProperties collection that describes the metadata stored in the workbook. Read-only.
CreateBackup True if a backup file is created when this file is saved. Read-only Boolean.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
Read-only Long.
CustomDocumentProperties Returns or sets
a DocumentProperties collection that
represents all the custom document properties for the specified workbook.
CustomViews Returns a CustomViews collection that represents all the custom views for the workbook.
CustomXMLParts Returns a CustomXMLParts collection that represents the custom XML in the XML data store. Read-only.
Date1904 True if the workbook uses the 1904 date system. Read/write Boolean.
DefaultPivotTableStyle Specifies the table style from
the TableStyles collection that is used as the default style for PivotTables. Read/write.
DefaultSlicerStyle Specifies the style from the TableStyles object that is used as the default style for slicers.
Read/write.
DefaultTableStyle Specifies the table style from
the TableStyles collection that is used as the default TableStyle. Read/write Variant.
DefaultTimelineStyle The name of the default slicer style of the workbook. Variant. Read/Write
DisplayDrawingObjects Returns or sets how shapes are displayed.
Read/write Long.
DisplayInkComments A Boolean value that determines whether ink comments are displayed in the workbook.
Read/write Boolean.
DocumentInspectors Returns a DocumentInspectors collection that represents the Document Inspector
modules for the specified workbook. Read-only.
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.
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 Excel 2007.
Read/write Boolean.
EnableAutoRecover Saves changed files, of all formats, on a timed interval. Read/write Boolean.
EncryptionProvider Returns a String specifying the name of the algorithm encryption provider that Microsoft Office Excel 2007 uses when encrypting documents. Read/write.
EnvelopeVisible True if the e-mail composition header and the envelope toolbar are both visible.
Read/write Boolean.
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.
Excel8CompatibilityMode The Excel8CompatibilityMode property provides developers with a way to check if the workbook is in compatibility mode. Read-only Boolean.
FileFormat Returns the file format and/or type of the workbook. Read-only XlFileFormat.
Final Returns or sets a Boolean that indicates
whether a workbook is final.
Read/writeBoolean.
ForceFullCalculation Returns or sets the specified workbook to forced calculation mode. Read/write.
FullName Returns the name of the object, including its path on disk, as a string. Read-onlyString.
FullNameURLEncoded Returns a String indicating the name of the object, including its path on disk, as a string.
Read-only.
HasPassword True if the workbook has a protection password. Read-only Boolean.
HasVBProject Returns a Boolean that represents whether a workbook has an attached Microsoft Visual Basic for Applications project. Read-only Boolean.
HighlightChangesOnScreen True if changes to the shared workbook are highlighted on-screen. Read/writeBoolean.
IconSets This property is used to filter data in a workbook based on a cell icon from theIconSet collection. Read-only.
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.
IsAddin True if the workbook is running as an add-in.
Read/write Boolean.
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.
KeepChangeHistory True if change tracking is enabled for the shared workbook. Read/write Boolean.
ListChangesOnNewSheet True if changes to the shared workbook are shown on a separate worksheet.
Read/write Boolean.
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.
Model Returns the top level Model object which is the one Data Model for the workbook. Read-only
MultiUserEditing True if the workbook is open as a shared list.
Read-only Boolean.
Name Returns a String value that represents the
name of the object.
Names Returns a Names collection that represents all the names in the specified workbook
(including all worksheet-specific names).
Read-only Names object.
Parent Returns the parent object for the specified object. Read-only.
Password Returns or sets the password that must be supplied to open the specified workbook.
Read/write String.
PasswordEncryptionAlgorithm Returns a String indicating the algorithm Microsoft Excel uses to encrypt passwords for the specified workbook. Read-only.
PasswordEncryptionFileProperties True if Microsoft Excel encrypts file properties for the specified password-protected
workbook. Read-only Boolean.
PasswordEncryptionKeyLength Returns a Long indicating the key length of the algorithm Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only.
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.
Path Returns a String that represents the complete
path to the workbook/file that this workbook object respresents.
Permission Returns a Permission object that represents the permission settings in the specified workbook.
PersonalViewListSettings True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean.
PersonalViewPrintSettings True if print settings are included in the user's personal view of the shared workbook. Read-write Boolean.
PivotTables Returns an object that represents a collection of all the PivotTable reports on a worksheet.
Read-only.
PrecisionAsDisplayed True if calculations in this workbook will be done using only the precision of the numbers as they’re displayed. Read/write Boolean.
ProtectStructure True if the order of the sheets in the workbook is protected. Read-only Boolean.
ProtectWindows True if the windows of the workbook are protected. Read-only Boolean.
PublishObjects Returns the PublishObjects collection. Read-only.
ReadOnly Returns True if the object has been opened as read-only. Read-only Boolean.
ReadOnlyRecommended True if the workbook was saved as read-only recommended. Read-only Boolean.
RemovePersonalInformation True if personal information can be removed from the specified workbook. The default value is False. Read/write Boolean.
Research Returns a Research object that represents the research service for a workbook. Read-only.
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.
Saved True if no changes have been made to the
specified workbook since it was last saved.
specified workbook since it was last saved.