ProtectStructure Property

Applies To

Workbook Object.

Description

True if the order of the sheets in the workbook is protected. Read-only.

See Also

Protect Method, ProtectWindows Property, Unprotect Method.

Example

This example displays a message if the structure of the active workbook is protected.

If ActiveWorkbook.ProtectStructure = True Then
    MsgBox "Remember, you cannot delete, add, or change " & Chr(13) & _
        "the location of any sheets in this workbook."
End If