Workbook.ProtectStructure Property

  • Article
Excel Developer Reference

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

Syntax

expression.ProtectStructure

expression   A variable that represents a Workbook object.

Example

This example displays a message if the order of the sheets in the active workbook is protected.

Visual Basic for Applications 
  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

See Also