Workbook Protection Members

The order of worksheets in a workbook can be protected from changes, as can the window and pane layout used to display the workbook. You can also use workbook protection to set passwords for shared workbooks.

The Workbook object has more than 200 members. The following Workbook members deal with protection; other Workbook members are described in Chapter 8:

    Protect
    ProtectSharing
    ProtectStructure
    ProtectWindows
    Unprotect
    UnprotectSharing

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