Workbook and Workbooks Members

Use the Workbooks collection to create new and open existing workbooks in Excel. Use the Application object’s Workbooks method to get a reference to this collection. Use the Workbook object to save and control individual workbooks. The Workbooks collection and Workbook object have the following members. Key members (shown in bold) are covered in the following reference section:

Tip

Password and protection members are covered in Chapter 26.

1 Collection only

2 Object and collection

AcceptAllChanges

AcceptLabelsInFormulas

Activate

ActiveChart

ActiveSheet

Add 1

AddToFavorites

Application 2

Author

AutoUpdateFrequency

AutoUpdateSaveChanges

BreakLink

BuiltinDocumentProperties

CalculationVersion

CanCheckIn

CanCheckOut 1

ChangeFileAccess

ChangeHistoryDuration

ChangeLink

Charts

CheckIn

CheckOut 1

Close 2

CodeName

Colors

CommandBars

Comments

ConflictResolution

Container (obsolete)

Count 1

CreateBackup

Creator 2

CustomDocumentProperties

CustomViews

Date1904

DeleteNumberFormat

DialogSheets (obsolete)

DisplayDrawingObjects

DisplayInkComments

DocumentLibraryVersions

EnableAutoRecover

EndReview

EnvelopeVisible

Excel4IntlMacroSheets

Excel4MacroSheets ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial