Workbook 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
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/write Boolean.
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-only String.
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/write Boolean.
IconSets	This property is used to filter data in a workbook based on a cell icon from the IconSet 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. Read/write Boolean.
SaveLinkValues	True if Microsoft Excel saves external link values with the workbook. Read/write Boolean.
ServerPolicy	Returns a ServerPolicy object that represents a policy specified for a workbook stored on a server running SharePoint Server 2007 or later. Read-only.
ServerViewableItems	Allows a developer to interact with the list of published objects in the workbook that are shown on the server. Read-only.
SharedWorkspace	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.
Sheets	Returns a Sheets collection that represents all the sheets in the specified workbook. Read-only Sheets object.
ShowConflictHistory	True if the Conflict History worksheet is visible in the workbook that's open as a shared list. Read/write Boolean.
ShowPivotChartActiveFields	This property controls the visibility of the PivotChart Filter Pane. Read/write Boolean.
ShowPivotTableFieldList	True (default) if the PivotTable field list can be shown. Read/write Boolean.
Signatures	Returns the digital signatures for a workbook. Read-only.
SlicerCaches	Returns the SlicerCaches object associated with the workbook. Read-only.
SmartDocument	Returns a SmartDocument object that represents the settings for a smart document solution. Read-only.
Styles	Returns a Styles collection that represents all the styles in the specified workbook. Read-only.
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.
TableStyles	Returns a TableStyles collection object for the current workbook that refers to the styles used in the current workbook. Read-only.
TemplateRemoveExtData	True if external data references are removed when the workbook is saved as a template. Read/write Boolean.
Theme	Returns the theme applied to the current workbook. Read-only.
UpdateLinks	Returns or sets an XlUpdateLink constant indicating a workbook's setting for updating embedded OLE links. Read/write.
UpdateRemoteReferences	True if Microsoft Excel updates remote references in the workbook. Read/write Boolean.
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.
UseWholeCellCriteria	True if the workbook uses search patterns that match the entire content of a cell. Read-only Boolean.
UseWildcards	True if the workbook enables wildcards for character string comparisons and searching. Read-only Boolean
VBASigned	True if the Visual Basic for Applications project for the specified workbook has been digitally signed. Read-only Boolean.
VBProject	Returns a VBProject object that represents the Visual Basic project in the specified workbook. Read-only.
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.
Windows	Returns a Windows collection that represents all the windows in the specified workbook. Read-only Windows object.
Worksheets	Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.
WritePassword	Returns or sets a String for the write password of a workbook. Read/write.
WriteReserved	True if the workbook is write-reserved. Read-only Boolean.
WriteReservedBy	Returns the name of the user who currently has write permission for the workbook. Read-only String.
XmlMaps	Returns an XmlMaps collection that represents the schema maps that have been added to the specified workbook. Read-only.
XmlNamespaces	Returns an XmlNamespaces collection that represents the XML namespaces contained in the specified workbook. Read-only.
Queries

Workbook Properties (Excel)

Properties

Additional resources