ÿþ<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><script> function getHelp(link) { window.open("http://" + location.hostname + "/Explorer/" + link, "_help", "left=400,resizable=yes,toolbar=yes,width=200,height=200,scrollbars=yes").focus(); } function showReturns(returns) { window.status = returns; } </script><head> <!--[if gte mso 9]><xml> <mso:CustomDocumentProperties> <mso:Order msdt:dt="string">348500.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>Chapter 08</title> <!--mstheme--><link rel="stylesheet" type="text/css" id="onetidThemeCSS" href="../_themes/simple/simp1011-1200.css"><meta name="Microsoft Theme" content="simple 1011, default"> </head><body> <H1>Excel File Objects</H1> <h2>Workbook (1995) <img src="MSGBOX02.ICO" alt="Represents a Microsoft Excel workbook. The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel." width="16" height="16" onclick="getHelp('xlobjWorkbook.htm');showMozHelp('Represents a Microsoft Excel workbook. The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.');"></h2>AcceptAllChanges([When], [Who], [Where]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Accepts all changes in the specified shared workbook." width="16" height="16" onclick="getHelp('xlmthAcceptAllChanges.htm')" onmouseover="showReturns('Returns: Void')"><br>AcceptLabelsInFormulas [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if labels can be used in worksheet formulas. The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAcceptLabelsInFormulas.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.htm')" onmouseover="showReturns('Returns: Void')"><br>ActiveChart<input type="image" src="MSGBOX02.ICO" alt="Returns: Chart. 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. Read-only." width="16" height="16" onclick="getHelp('xlproActiveChart.htm')" onmouseover="showReturns('Returns: Chart')"><br>ActiveSheet<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. 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. Read-only." width="16" height="16" onclick="getHelp('xlproActiveSheet.htm')" onmouseover="showReturns('Returns: Object')"><br>AddinInstall<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the workbook is installed as an add-in" width="16" height="16" onclick="getHelp('xlevtAddinInstall.htm')" onmouseover="showReturns('Returns: ')"><br>AddinUninstall<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the workbook is uninstalled as an add-in." width="16" height="16" onclick="getHelp('xlevtAddinUninstall.htm')" onmouseover="showReturns('Returns: ')"><br>AddToFavorites() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Adds a shortcut to the workbook or hyperlink to the Favorites folder." width="16" height="16" onclick="getHelp('xlmthAddToFavorites.htm')" onmouseover="showReturns('Returns: Void')"><br>AfterXmlExport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>AfterXmlImport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Author [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the author of the comment. Read-only String." width="16" height="16" onclick="getHelp('xlproAuthor.htm')" onmouseover="showReturns('Returns: String')"><br>AutoUpdateFrequency [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of minutes between automatic updates to the shared workbook. If this property is set to zero (0), updates occur only when the workbook is saved. Read/write Long." width="16" height="16" onclick="getHelp('xlproAutoUpdateFrequency.htm')" onmouseover="showReturns('Returns: Int32')"><br>AutoUpdateSaveChanges [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if current changes to the shared workbook are posted to other users whenever the workbook is automatically updated. False if changes arent posted (this workbook is still synchronized with changes made by other users). The default value is True. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoUpdateSaveChanges.htm')" onmouseover="showReturns('Returns: Boolean')"><br>BeforeClose<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes." width="16" height="16" onclick="getHelp('xlevtBeforeClose.htm')" onmouseover="showReturns('Returns: ')"><br>BeforePrint<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs before the workbook (or anything in it) is printed." width="16" height="16" onclick="getHelp('xlevtBeforePrint.htm')" onmouseover="showReturns('Returns: ')"><br>BeforeSave<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs before the workbook is saved." width="16" height="16" onclick="getHelp('xlevtBeforeSave.htm')" onmouseover="showReturns('Returns: ')"><br>BeforeXmlExport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>BeforeXmlImport<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>BreakLink(Name, Type) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Converts formulas linked to other Microsoft Excel sources or OLE sources to values." width="16" height="16" onclick="getHelp('xlmthBreakLink.htm')" onmouseover="showReturns('Returns: Void')"><br>BuiltinDocumentProperties<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns a DocumentProperties collection that represents all the built-in document properties for the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproBuiltinDocumentProperties.htm')" onmouseover="showReturns('Returns: Object')"><br>CalculationVersion<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. If the workbook was saved in an earlier version of Excel and if the workbook hasn't been fully recalculated, then this property returns 0." width="16" height="16" onclick="getHelp('xlproCalculationVersion.htm')" onmouseover="showReturns('Returns: Int32')"><br>CanCheckIn() <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthCanCheckIn.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ChangeFileAccess(Mode, [WritePassword], [Notify]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. If you have a file open in read-only mode, you don't have exclusive access to the file. If you change a file from read-only to read/write, Microsoft Excel must load a new copy of the file to ensure that no changes were made while you had the file open as read-only." width="16" height="16" onclick="getHelp('xlmthChangeFileAccess.htm')" onmouseover="showReturns('Returns: Void')"><br>ChangeHistoryDuration [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of days shown in the shared workbook's change history. Read/write Long." width="16" height="16" onclick="getHelp('xlproChangeHistoryDuration.htm')" onmouseover="showReturns('Returns: Int32')"><br>ChangeLink(Name, NewName, [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example changes a Microsoft Excel link." width="16" height="16" onclick="getHelp('xlmthChangeLink.htm')" onmouseover="showReturns('Returns: Void')"><br>Charts<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Using this property without an object qualifier returns all chart sheets in the active workbook." width="16" height="16" onclick="getHelp('xlproCharts.htm')" onmouseover="showReturns('Returns: Sheets')"><br>CheckIn([SaveChanges], [Comments], [MakePublic]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Performs a check-in (with or without publish) or undo-check-out of the working copy on the server. Read/write." width="16" height="16" onclick="getHelp('xlmthCheckIn.htm')" onmouseover="showReturns('Returns: Void')"><br>Close([SaveChanges], [Filename], [RouteWorkbook]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Closing a workbook from Visual Basic doesn't run any Auto_Close macros in the workbook. Use the RunAutoMacros method to run the auto close macros." width="16" height="16" onclick="getHelp('xlmthClose.htm')" onmouseover="showReturns('Returns: Void')"><br>CodeName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the code name for the object. Read-only String." width="16" height="16" onclick="getHelp('xlproCodeName.htm')" onmouseover="showReturns('Returns: String')"><br>Colors [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets colors in the palette for the workbook. The palette has 56 entries, each represented by an RGB value. Read/write Variant." width="16" height="16" onclick="getHelp('xlproColors.htm')" onmouseover="showReturns('Returns: Object')"><br>CommandBars<input type="image" src="MSGBOX02.ICO" alt="Returns: CommandBars. Returns a CommandBars object that represents the Microsoft Excel command bars. Read-only." width="16" height="16" onclick="getHelp('xlproCommandBars.htm')" onmouseover="showReturns('Returns: CommandBars')"><br>Comments [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a Comments collection that represents all the comments for the specified worksheet. Read-only." width="16" height="16" onclick="getHelp('xlproComments.htm')" onmouseover="showReturns('Returns: String')"><br>ConflictResolution [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlSaveConflictResolution. Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated. Read/write XlSaveConflictResolution." width="16" height="16" onclick="getHelp('xlproConflictResolution.htm')" onmouseover="showReturns('Returns: XlSaveConflictResolution')"><br>Container<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the object that contains the specified embedded workbook. Read-only Object." width="16" height="16" onclick="getHelp('xlproContainer.htm')" onmouseover="showReturns('Returns: Object')"><br>CreateBackup<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if a backup file is created when this file is saved. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproCreateBackup.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CreateObjRef(requestedType) <input type="image" src="MSGBOX02.ICO" alt="Returns: ObjRef. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ObjRef')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>CustomDocumentProperties<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets a DocumentProperties collection that represents all the custom document properties for the specified workbook." width="16" height="16" onclick="getHelp('xlproCustomDocumentProperties.htm')" onmouseover="showReturns('Returns: Object')"><br>CustomViews<input type="image" src="MSGBOX02.ICO" alt="Returns: CustomViews. Returns a CustomViews collection that represents all the custom views for the workbook." width="16" height="16" onclick="getHelp('xlproCustomViews.htm')" onmouseover="showReturns('Returns: CustomViews')"><br>Date1904 [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook uses the 1904 date system. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDate1904.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Deactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the chart, worksheet, or workbook is deactivated." width="16" height="16" onclick="getHelp('xlevtDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>DeleteNumberFormat(NumberFormat) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deletes a custom number format from the workbook." width="16" height="16" onclick="getHelp('xlmthDeleteNumberFormat.htm')" onmouseover="showReturns('Returns: Void')"><br>DialogSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Sheets')"><br>DisplayDrawingObjects [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlDisplayDrawingObjects. Returns or sets how shapes are displayed. Read/write Long." width="16" height="16" onclick="getHelp('xlproDisplayDrawingObjects.htm')" onmouseover="showReturns('Returns: XlDisplayDrawingObjects')"><br>DisplayInkComments [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DocumentLibraryVersions<input type="image" src="MSGBOX02.ICO" alt="Returns: DocumentLibraryVersions. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: DocumentLibraryVersions')"><br>Dummy16() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Dummy17(calcid) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>EnableAutoRecover [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Saves changed files, of all formats, on a timed interval.&amp;nbsp;If Microsoft Excel fails, the system fails, or if the system is improperly shut down (not allowing Excel to save the changed files), the backed up files are opened and the user has an opportunity to save changes that otherwise would have been lost. When the user restarts Excel, a document recovery window opens, giving the user an option to recover the files they were working on. Setting this property to True (default) enables this feature. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnableAutoRecover.htm')" onmouseover="showReturns('Returns: Boolean')"><br>EndReview() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Terminates a review of a file that has been sent for review using the SendForReview method." width="16" height="16" onclick="getHelp('xlmthEndReview.htm')" onmouseover="showReturns('Returns: Void')"><br>EnvelopeVisible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the e-mail composition header and the envelope toolbar are both visible. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproEnvelopeVisible.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Equals(obj) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Excel4IntlMacroSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproExcel4IntlMacroSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>Excel4MacroSheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproExcel4MacroSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>ExclusiveAccess() <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Assigns the current user exclusive access to the workbook that's open as a shared list." width="16" height="16" onclick="getHelp('xlmthExclusiveAccess.htm')" onmouseover="showReturns('Returns: Boolean')"><br>FileFormat<input type="image" src="MSGBOX02.ICO" alt="Returns: XlFileFormat. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that youve selected or installed." width="16" height="16" onclick="getHelp('xlproFileFormat.htm')" onmouseover="showReturns('Returns: XlFileFormat')"><br>FollowHyperlink(Address, [SubAddress], [NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Displays a cached document, if its already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application." width="16" height="16" onclick="getHelp('xlmthFollowHyperlink.htm')" onmouseover="showReturns('Returns: Void')"><br>ForwardMailer() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthForwardMailer.htm')" onmouseover="showReturns('Returns: Void')"><br>FullName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name of the object, including its path on disk, as a string. Read-only String." width="16" height="16" onclick="getHelp('xlproFullName.htm')" onmouseover="showReturns('Returns: String')"><br>FullNameURLEncoded<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a String indicating the name of the object, including its path on disk, as a string. Read-only." width="16" height="16" onclick="getHelp('xlproFullNameURLEncoded.htm')" onmouseover="showReturns('Returns: String')"><br>GetHashCode() <input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Int32')"><br>GetLifetimeService() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>GetType() <input type="image" src="MSGBOX02.ICO" alt="Returns: Type. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Type')"><br>HasMailer [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HasPassword<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook has a protection password. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproHasPassword.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HasRoutingSlip [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook has a routing slip. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproHasRoutingSlip.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HighlightChangesOnScreen [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if changes to the shared workbook are highlighted on-screen. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproHighlightChangesOnScreen.htm')" onmouseover="showReturns('Returns: Boolean')"><br>HighlightChangesOptions([When], [Who], [Where]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Controls how changes are shown in a shared workbook." width="16" height="16" onclick="getHelp('xlmthHighlightChangesOptions.htm')" onmouseover="showReturns('Returns: Void')"><br>HTMLProject<input type="image" src="MSGBOX02.ICO" alt="Returns: HTMLProject. Returns the HTMLProject object in the specified workbook, which represents a top-level project branch, as in the Project Explorer in the Microsoft Script Editor. Read-only." width="16" height="16" onclick="getHelp('xlproHTMLProject.htm')" onmouseover="showReturns('Returns: HTMLProject')"><br>InactiveListBorderVisible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>InitializeLifetimeService() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Object')"><br>IsAddin [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook is running as an add-in. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproIsAddin.htm')" onmouseover="showReturns('Returns: Boolean')"><br>IsInplace<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Boolean')"><br>KeepChangeHistory [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if change tracking is enabled for the shared workbook. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproKeepChangeHistory.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Keywords [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>LinkInfo(Name, LinkInfo, [Type], [EditionRef]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example displays a message box if the link is updated automatically." width="16" height="16" onclick="getHelp('xlmthLinkInfo.htm')" onmouseover="showReturns('Returns: Object')"><br>LinkSources([Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. The format of the array is a one-dimensional array for all types but publisher and subscriber. The returned strings contain the name of the link source, in the appropriate notation for the link type. For example, DDE links use the Server|Document!Item syntax." width="16" height="16" onclick="getHelp('xlmthLinkSources.htm')" onmouseover="showReturns('Returns: Object')"><br>ListChangesOnNewSheet [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if changes to the shared workbook are shown on a separate worksheet. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproListChangesOnNewSheet.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Mailer<input type="image" src="MSGBOX02.ICO" alt="Returns: Mailer. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproMailer.htm')" onmouseover="showReturns('Returns: Mailer')"><br>MergeWorkbook(Filename) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Merges changes from one workbook into an open workbook." width="16" height="16" onclick="getHelp('xlmthMergeWorkbook.htm')" onmouseover="showReturns('Returns: Void')"><br>Modules<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Sheets')"><br>MultiUserEditing<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook is open as a shared list. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproMultiUserEditing.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Names<input type="image" src="MSGBOX02.ICO" alt="Returns: Names. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlproNames.htm')" onmouseover="showReturns('Returns: Names')"><br>NewSheet<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when a new sheet is created in the workbook." width="16" height="16" onclick="getHelp('xlevtNewSheet.htm')" onmouseover="showReturns('Returns: ')"><br>NewWindow() <input type="image" src="MSGBOX02.ICO" alt="Returns: Window. Creates a new window or a copy of the specified window." width="16" height="16" onclick="getHelp('xlmthNewWindow.htm')" onmouseover="showReturns('Returns: Window')"><br>OnSave [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnSheetActivate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>OnSheetDeactivate [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>Open<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the workbook is opened." width="16" height="16" onclick="getHelp('xlevtOpen.htm')" onmouseover="showReturns('Returns: ')"><br>OpenLinks(Name, [ReadOnly], [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example opens OLE link one in the active workbook." width="16" height="16" onclick="getHelp('xlmthOpenLinks.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Password [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the password that must be supplied to open the specified workbook. Read/write String." width="16" height="16" onclick="getHelp('xlproPassword.htm')" onmouseover="showReturns('Returns: String')"><br>PasswordEncryptionAlgorithm<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a String indicating the algorithm Microsoft Excel uses to encrypt passwords for the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproPasswordEncryptionAlgorithm.htm')" onmouseover="showReturns('Returns: String')"><br>PasswordEncryptionFileProperties<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel encrypts file properties for the specified password-protected workbook. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproPasswordEncryptionFileProperties.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PasswordEncryptionKeyLength<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns a Long indicating the key length of the algorithm Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproPasswordEncryptionKeyLength.htm')" onmouseover="showReturns('Returns: Int32')"><br>PasswordEncryptionProvider<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns a String specifying the name of the algorithm encryption provider that Microsoft Excel uses when encrypting passwords for the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproPasswordEncryptionProvider.htm')" onmouseover="showReturns('Returns: String')"><br>Path<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Path property as it applies to the AutoRecover object." width="16" height="16" onclick="getHelp('xlproPath.htm')" onmouseover="showReturns('Returns: String')"><br>Permission<input type="image" src="MSGBOX02.ICO" alt="Returns: Permission. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Permission')"><br>PersonalViewListSettings [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if filter and sort settings for lists are included in the user's personal view of the shared workbook. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPersonalViewListSettings.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PersonalViewPrintSettings [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if print settings are included in the user's personal view of the shared workbook. Read-write Boolean." width="16" height="16" onclick="getHelp('xlproPersonalViewPrintSettings.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PivotCaches() <input type="image" src="MSGBOX02.ICO" alt="Returns: PivotCaches. Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlmthPivotCaches.htm')" onmouseover="showReturns('Returns: PivotCaches')"><br>PivotTableCloseConnection<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after a PivotTable report closes the connection to its data source." width="16" height="16" onclick="getHelp('xlevtPivotTableCloseConnection.htm')" onmouseover="showReturns('Returns: ')"><br>PivotTableOpenConnection<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after a PivotTable report opens the connection to its data source." width="16" height="16" onclick="getHelp('xlevtPivotTableOpenConnection.htm')" onmouseover="showReturns('Returns: ')"><br>PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Creates a PivotTable object. This method doesnt display the PivotTable Wizard. This method isnt available for OLE DB data sources. Use the Add method to add a PivotTable cache, and then create a PivotTable report based on the cache. PivotTable object." width="16" height="16" onclick="getHelp('xlmthPivotTableWizard.htm')" onmouseover="showReturns('Returns: Void')"><br>Post([DestName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Posts the specified workbook to a public folder. This method works only with a Microsoft Exchange client connected to a Microsoft Exchange server." width="16" height="16" onclick="getHelp('xlmthPost.htm')" onmouseover="showReturns('Returns: Void')"><br>PrecisionAsDisplayed [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if calculations in this workbook will be done using only the precision of the numbers as theyre displayed. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproPrecisionAsDisplayed.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Prints the object." width="16" height="16" onclick="getHelp('xlmthPrintOut.htm')" onmouseover="showReturns('Returns: Void')"><br>PrintPreview([EnableChanges]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Shows a preview of the object as it would look when printed." width="16" height="16" onclick="getHelp('xlmthPrintPreview.htm')" onmouseover="showReturns('Returns: Void')"><br>Protect([Password], [Structure], [Windows]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. If you apply the Protect method with the UserInterfaceOnly argument set to True to a worksheet and then save the workbook, the entire worksheet (not just the interface) will be fully protected when you reopen the workbook. To re-enable the user interface protection after the workbook is opened, you must again apply the Protect method with UserInterfaceOnly set to True." width="16" height="16" onclick="getHelp('xlmthProtect.htm')" onmouseover="showReturns('Returns: Void')"><br>ProtectSharing([Filename], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [SharingPassword]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves the workbook and protects it for sharing." width="16" height="16" onclick="getHelp('xlmthProtectSharing.htm')" onmouseover="showReturns('Returns: Void')"><br>ProtectStructure<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the order of the sheets in the workbook is protected. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproProtectStructure.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ProtectWindows<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the windows of the workbook are protected. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproProtectWindows.htm')" onmouseover="showReturns('Returns: Boolean')"><br>PublishObjects<input type="image" src="MSGBOX02.ICO" alt="Returns: PublishObjects. Returns the PublishObjects collection. Read-only." width="16" height="16" onclick="getHelp('xlproPublishObjects.htm')" onmouseover="showReturns('Returns: PublishObjects')"><br>PurgeChangeHistoryNow(Days, [SharingPassword]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Removes entries from the change log for the specified workbook." width="16" height="16" onclick="getHelp('xlmthPurgeChangeHistoryNow.htm')" onmouseover="showReturns('Returns: Void')"><br>ReadOnly<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook has been opened as read-only. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproReadOnly.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ReadOnlyRecommended [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook was saved as read-only recommended. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproReadOnlyRecommended.htm')" onmouseover="showReturns('Returns: Boolean')"><br>RecheckSmartTags() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Causes a foreground smart tag check to occur automatically annotating data that was not annotated before." width="16" height="16" onclick="getHelp('xlmthRecheckSmartTags.htm')" onmouseover="showReturns('Returns: Void')"><br>RefreshAll() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Refreshes all external data ranges and PivotTable reports in the specified workbook." width="16" height="16" onclick="getHelp('xlmthRefreshAll.htm')" onmouseover="showReturns('Returns: Void')"><br>RejectAllChanges([When], [Who], [Where]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Rejects all changes in the specified shared workbook." width="16" height="16" onclick="getHelp('xlmthRejectAllChanges.htm')" onmouseover="showReturns('Returns: Void')"><br>ReloadAs(Encoding) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Reloads a workbook based on an HTML document, using the specified document encoding." width="16" height="16" onclick="getHelp('xlmthReloadAs.htm')" onmouseover="showReturns('Returns: Void')"><br>RemovePersonalInformation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if personal information can be removed from the specified workbook. The default value is False. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproRemovePersonalInformation.htm')" onmouseover="showReturns('Returns: Boolean')"><br>RemoveUser(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Disconnects the specified user from the shared workbook." width="16" height="16" onclick="getHelp('xlmthRemoveUser.htm')" onmouseover="showReturns('Returns: Void')"><br>Reply() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthReply.htm')" onmouseover="showReturns('Returns: Void')"><br>ReplyAll() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthReplyAll.htm')" onmouseover="showReturns('Returns: Void')"><br>ReplyWithChanges([ShowMessage]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. 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." width="16" height="16" onclick="getHelp('xlmthReplyWithChanges.htm')" onmouseover="showReturns('Returns: Void')"><br>ResetColors() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Resets the color palette to the default colors." width="16" height="16" onclick="getHelp('xlmthResetColors.htm')" onmouseover="showReturns('Returns: Void')"><br>RevisionNumber<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. 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." width="16" height="16" onclick="getHelp('xlproRevisionNumber.htm')" onmouseover="showReturns('Returns: Int32')"><br>Route() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Routes the workbook, using the workbook's current routing slip." width="16" height="16" onclick="getHelp('xlmthRoute.htm')" onmouseover="showReturns('Returns: Void')"><br>Routed<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook has been routed to the next recipient. False if the workbook needs to be routed. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproRouted.htm')" onmouseover="showReturns('Returns: Boolean')"><br>RoutingSlip<input type="image" src="MSGBOX02.ICO" alt="Returns: RoutingSlip. Returns a RoutingSlip object that represents the routing slip for the workbook. Reading this property if there's no routing slip causes an error (check the HasRoutingSlip property first). Read-only." width="16" height="16" onclick="getHelp('xlproRoutingSlip.htm')" onmouseover="showReturns('Returns: RoutingSlip')"><br>RunAutoMacros(Which) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. 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." width="16" height="16" onclick="getHelp('xlmthRunAutoMacros.htm')" onmouseover="showReturns('Returns: Void')"><br>Save() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves changes to the specified workbook." width="16" height="16" onclick="getHelp('xlmthSave.htm')" onmouseover="showReturns('Returns: Void')"><br>SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout], [Local]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves changes to the chart or worksheet in a different file." width="16" height="16" onclick="getHelp('xlmthSaveAs.htm')" onmouseover="showReturns('Returns: Void')"><br>SaveAsXMLData(Filename, Map) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SaveCopyAs([Filename]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Saves a copy of the workbook to a file but doesn't modify the open workbook in memory." width="16" height="16" onclick="getHelp('xlmthSaveCopyAs.htm')" onmouseover="showReturns('Returns: Void')"><br>Saved [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if no changes have been made to the specified workbook since it was last saved. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproSaved.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SaveLinkValues [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel saves external link values with the workbook. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproSaveLinkValues.htm')" onmouseover="showReturns('Returns: Boolean')"><br>sblt(s) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SendFaxOverInternet([Recipients], [Subject], [ShowMessage]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SendForReview([Recipients], [Subject], [ShowMessage], [IncludeAttachment]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sends a workbook in an e-mail message for review to the specified recipients." width="16" height="16" onclick="getHelp('xlmthSendForReview.htm')" onmouseover="showReturns('Returns: Void')"><br>SendMail(Recipients, [Subject], [ReturnReceipt]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sends the workbook by using the installed mail system." width="16" height="16" onclick="getHelp('xlmthSendMail.htm')" onmouseover="showReturns('Returns: Void')"><br>SendMailer([FileFormat], [Priority]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('xlmthSendMailer.htm')" onmouseover="showReturns('Returns: Void')"><br>SetLinkOnData(Name, [Procedure]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the name of a procedure that runs whenever a DDE link is updated." width="16" height="16" onclick="getHelp('xlmthSetLinkOnData.htm')" onmouseover="showReturns('Returns: Void')"><br>SetPasswordEncryptionOptions([PasswordEncryptionProvider], [PasswordEncryptionAlgorithm], [PasswordEncryptionKeyLength], [PasswordEncryptionFileProperties]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the options for encrypting workbooks using passwords." width="16" height="16" onclick="getHelp('xlmthSetPasswordEncryptionOptions.htm')" onmouseover="showReturns('Returns: Void')"><br>SharedWorkspace<input type="image" src="MSGBOX02.ICO" alt="Returns: SharedWorkspace. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: SharedWorkspace')"><br>SheetActivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any sheet is activated." width="16" height="16" onclick="getHelp('xlevtSheetActivate.htm')" onmouseover="showReturns('Returns: ')"><br>SheetBeforeDoubleClick<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any worksheet is double-clicked, before the default double-click action." width="16" height="16" onclick="getHelp('xlevtSheetBeforeDoubleClick.htm')" onmouseover="showReturns('Returns: ')"><br>SheetBeforeRightClick<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any worksheet is right-clicked, before the default right-click action." width="16" height="16" onclick="getHelp('xlevtSheetBeforeRightClick.htm')" onmouseover="showReturns('Returns: ')"><br>SheetCalculate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after any worksheet is recalculated or after any changed data is plotted on a chart." width="16" height="16" onclick="getHelp('xlevtSheetCalculate.htm')" onmouseover="showReturns('Returns: ')"><br>SheetChange<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when cells in any worksheet are changed by the user or by an external link." width="16" height="16" onclick="getHelp('xlevtSheetChange.htm')" onmouseover="showReturns('Returns: ')"><br>SheetDeactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any sheet is deactivated." width="16" height="16" onclick="getHelp('xlevtSheetDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>SheetFollowHyperlink<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when you click any hyperlink in Microsoft Excel. For worksheet-level events, see the Help topic for the FollowHyperlink event." width="16" height="16" onclick="getHelp('xlevtSheetFollowHyperlink.htm')" onmouseover="showReturns('Returns: ')"><br>SheetPivotTableUpdate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs after the sheet of the PivotTable report has been updated." width="16" height="16" onclick="getHelp('xlevtSheetPivotTableUpdate.htm')" onmouseover="showReturns('Returns: ')"><br>Sheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. Returns a Sheets collection that represents all the sheets in the active workbook, for an Application object. Returns a Sheets collection that represents all the sheets in the specified workbook, for a Workbook object. Read-only Sheets object." width="16" height="16" onclick="getHelp('xlproSheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>SheetSelectionChange<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet)." width="16" height="16" onclick="getHelp('xlevtSheetSelectionChange.htm')" onmouseover="showReturns('Returns: ')"><br>ShowConflictHistory [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the Conflict History worksheet is visible in the workbook that's open as a shared list. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowConflictHistory.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowPivotTableFieldList [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True (default) if the PivotTable field list can be shown. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowPivotTableFieldList.htm')" onmouseover="showReturns('Returns: Boolean')"><br>SmartDocument<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartDocument. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: SmartDocument')"><br>SmartTagOptions<input type="image" src="MSGBOX02.ICO" alt="Returns: SmartTagOptions. Returns a SmartTagOptions object representing the options that can be performed with a smart tag." width="16" height="16" onclick="getHelp('xlproSmartTagOptions.htm')" onmouseover="showReturns('Returns: SmartTagOptions')"><br>Styles<input type="image" src="MSGBOX02.ICO" alt="Returns: Styles. Returns a Styles collection that represents all the styles in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproStyles.htm')" onmouseover="showReturns('Returns: Styles')"><br>Subject [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the subject for the mailer or routing slip. Read/write String." width="16" height="16" onclick="getHelp('xlproSubject.htm')" onmouseover="showReturns('Returns: String')"><br>Sync<input type="image" src="MSGBOX02.ICO" alt="Returns: Sync. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Sync')"><br>TemplateRemoveExtData [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if external data references are removed when the workbook is saved as a template. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproTemplateRemoveExtData.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Title [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the title of the Web page when the document is saved as a Web page. Read/write String." width="16" height="16" onclick="getHelp('xlproTitle.htm')" onmouseover="showReturns('Returns: String')"><br>ToggleFormsDesign() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>ToString() <input type="image" src="MSGBOX02.ICO" alt="Returns: String. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: String')"><br>Unprotect([Password]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected." width="16" height="16" onclick="getHelp('xlmthUnprotect.htm')" onmouseover="showReturns('Returns: Void')"><br>UnprotectSharing([SharingPassword]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Turns off protection for sharing and saves the workbook." width="16" height="16" onclick="getHelp('xlmthUnprotectSharing.htm')" onmouseover="showReturns('Returns: Void')"><br>UpdateFromFile() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. 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." width="16" height="16" onclick="getHelp('xlmthUpdateFromFile.htm')" onmouseover="showReturns('Returns: Void')"><br>UpdateLink([Name], [Type]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Updates a Microsoft Excel, DDE, or OLE link (or links)." width="16" height="16" onclick="getHelp('xlmthUpdateLink.htm')" onmouseover="showReturns('Returns: Void')"><br>UpdateLinks [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlUpdateLinks. Returns or sets an XlUpdateLink constant indicating a workbook's setting for updating embedded OLE links. Read/write." width="16" height="16" onclick="getHelp('xlproUpdateLinks.htm')" onmouseover="showReturns('Returns: XlUpdateLinks')"><br>UpdateRemoteReferences [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel updates remote references in for the workbook. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproUpdateRemoteReferences.htm')" onmouseover="showReturns('Returns: Boolean')"><br>UserControl [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. 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." width="16" height="16" onclick="getHelp('xlproUserControl.htm')" onmouseover="showReturns('Returns: Boolean')"><br>UserStatus<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns a 1-based, two-dimensional array that provides information about each user who has the workbook open as a shared list. The first element of the second dimension is the name of the user, the second element is the date and time when the user last opened the workbook, and the third element is a number indicating the type of list (1 indicates exclusive, and 2 indicates shared). Read-only Variant." width="16" height="16" onclick="getHelp('xlproUserStatus.htm')" onmouseover="showReturns('Returns: Object')"><br>VBASigned<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the Visual Basic for Applications project for the specified workbook has been digitally signed. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproVBASigned.htm')" onmouseover="showReturns('Returns: Boolean')"><br>VBProject<input type="image" src="MSGBOX02.ICO" alt="Returns: VBProject. Returns a VBProject object that represents the Visual Basic project in the specified workbook. Read-only." width="16" height="16" onclick="getHelp('xlproVBProject.htm')" onmouseover="showReturns('Returns: VBProject')"><br>WebOptions<input type="image" src="MSGBOX02.ICO" alt="Returns: 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." width="16" height="16" onclick="getHelp('xlproWebOptions.htm')" onmouseover="showReturns('Returns: WebOptions')"><br>WebPagePreview() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Displays a preview of the specified workbook as it would look if saved as a Web page." width="16" height="16" onclick="getHelp('xlmthWebPagePreview.htm')" onmouseover="showReturns('Returns: Void')"><br>WindowActivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook window is activated." width="16" height="16" onclick="getHelp('xlevtWindowActivate.htm')" onmouseover="showReturns('Returns: ')"><br>WindowDeactivate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook window is deactivated." width="16" height="16" onclick="getHelp('xlevtWindowDeactivate.htm')" onmouseover="showReturns('Returns: ')"><br>WindowResize<input type="image" src="MSGBOX02.ICO" alt="Returns: . Occurs when any workbook window is resized." width="16" height="16" onclick="getHelp('xlevtWindowResize.htm')" onmouseover="showReturns('Returns: ')"><br>Windows<input type="image" src="MSGBOX02.ICO" alt="Returns: Windows. For an Application object, returns a Windows collection that represents all the windows in all the workbooks. For a Workbook object, returns a Windows collection that represents all the windows in the specified workbook. Read-only Windows object." width="16" height="16" onclick="getHelp('xlproWindows.htm')" onmouseover="showReturns('Returns: Windows')"><br>WorkbookEvents_Event_Activate<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>WorkbookEvents_Event_Sync<input type="image" src="MSGBOX02.ICO" alt="Returns: . Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: ')"><br>Worksheets<input type="image" src="MSGBOX02.ICO" alt="Returns: Sheets. 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." width="16" height="16" onclick="getHelp('xlproWorksheets.htm')" onmouseover="showReturns('Returns: Sheets')"><br>WritePassword [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets a String for the write password of a workbook. Read/write." width="16" height="16" onclick="getHelp('xlproWritePassword.htm')" onmouseover="showReturns('Returns: String')"><br>WriteReserved<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the workbook is write-reserved. Read-only Boolean." width="16" height="16" onclick="getHelp('xlproWriteReserved.htm')" onmouseover="showReturns('Returns: Boolean')"><br>WriteReservedBy<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name of the user who currently has write permission for the workbook. Read-only String." width="16" height="16" onclick="getHelp('xlproWriteReservedBy.htm')" onmouseover="showReturns('Returns: String')"><br>XmlImport(Url, ImportMap, [Overwrite], [Destination]) <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlImportResult. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XlXmlImportResult')"><br>XmlImportXml(Data, ImportMap, [Overwrite], [Destination]) <input type="image" src="MSGBOX02.ICO" alt="Returns: XlXmlImportResult. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XlXmlImportResult')"><br>XmlMaps<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlMaps. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlMaps')"><br>XmlNamespaces<input type="image" src="MSGBOX02.ICO" alt="Returns: XmlNamespaces. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: XmlNamespaces')"><br><h2>WorkbookEvents (1997) <img src="MSGBOX02.ICO" alt="Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm');showMozHelp('Hidden or unsupported element.');"></h2>Activate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example activates Sheet1." width="16" height="16" onclick="getHelp('xlmthActivate.htm')" onmouseover="showReturns('Returns: Void')"><br>AddinInstall() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>AddinUninstall() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>AfterXmlExport(Map, Url, Result) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>AfterXmlImport(Map, IsRefresh, Result) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforeClose(Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforePrint(Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforeSave(SaveAsUI, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforeXmlExport(Map, Url, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>BeforeXmlImport(Map, Url, IsRefresh, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Deactivate() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>NewSheet(Sh) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Open() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example opens the workbook Analysis.xls and then runs its Auto_Open macro." width="16" height="16" onclick="getHelp('xlmthOpen.htm')" onmouseover="showReturns('Returns: Void')"><br>PivotTableCloseConnection(Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>PivotTableOpenConnection(Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetActivate(Sh) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetBeforeDoubleClick(Sh, Target, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetBeforeRightClick(Sh, Target, Cancel) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetCalculate(Sh) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetChange(Sh, Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetDeactivate(Sh) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetFollowHyperlink(Sh, Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetPivotTableUpdate(Sh, Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>SheetSelectionChange(Sh, Target) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>Sync(SyncEventType) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>WindowActivate(Wn) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>WindowDeactivate(Wn) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br>WindowResize(Wn) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>Workbooks (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Workbook objects that are currently open in the Microsoft Excel application." width="16" height="16" onclick="getHelp('xlobjWorkbooks.htm');showMozHelp('A collection of all the Workbook objects that are currently open in the Microsoft Excel application.');"></h2>Add([Template]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Workbook')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. 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 that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>CanCheckOut(Filename) <input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel can check out a specified workbook from a server. Read/write Boolean." width="16" height="16" onclick="getHelp('xlmthCanCheckOut.htm')" onmouseover="showReturns('Returns: Boolean')"><br>CheckOut(Filename) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Returns a String representing a specified workbook from a server to a local computer for editing." width="16" height="16" onclick="getHelp('xlmthCheckOut.htm')" onmouseover="showReturns('Returns: Void')"><br>Close() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Closing a workbook from Visual Basic doesn't run any Auto_Close macros in the workbook. Use the RunAutoMacros method to run the auto close macros." width="16" height="16" onclick="getHelp('xlmthClose.htm')" onmouseover="showReturns('Returns: Void')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item<input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. Using the Item property of the Dialogs collection and the Show method, you can display approximately 200 built-in dialog boxes. Each dialog box has a constant assigned to it; these constants all begin with xlDialog." width="16" height="16" onclick="getHelp('xlproItem.htm')" onmouseover="showReturns('Returns: Workbook')"><br>Open(Filename, [UpdateLinks], [ReadOnly], [Format], [Password], [WriteResPassword], [IgnoreReadOnlyRecommended], [Origin], [Delimiter], [Editable], [Notify], [Converter], [AddToMru], [Local], [CorruptLoad]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. This example opens the workbook Analysis.xls and then runs its Auto_Open macro." width="16" height="16" onclick="getHelp('xlmthOpen.htm')" onmouseover="showReturns('Returns: Workbook')"><br>OpenDatabase(Filename, [CommandText], [CommandType], [BackgroundQuery], [ImportDataAs]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. Returns a Workbook object representing a database." width="16" height="16" onclick="getHelp('xlmthOpenDatabase.htm')" onmouseover="showReturns('Returns: Workbook')"><br>OpenText(Filename, [Origin], [StartRow], [DataType], [TextQualifier], [ConsecutiveDelimiter], [Tab], [Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [TextVisualLayout], [DecimalSeparator], [ThousandsSeparator], [TrailingMinusNumbers], [Local]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example opens the file Data.txt and uses tab delimiters to parse the text file into a worksheet." width="16" height="16" onclick="getHelp('xlmthOpenText.htm')" onmouseover="showReturns('Returns: Void')"><br>OpenXML(Filename, [Stylesheets], [LoadOption]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Workbook. Returns a Workbook object representing an XML file in Microsoft Excel." width="16" height="16" onclick="getHelp('xlmthOpenXML.htm')" onmouseover="showReturns('Returns: Workbook')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br></body> </html>