Share via

ProtectStructure Property [Excel 2003 VBA Language Reference]

  • Article

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

Example

This example displays a message if the order of the sheets in 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

Applies to | Workbook Object

See Also | Protect Method | ProtectWindows Property | Unprotect Method