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
Don't allow sheets to be rearranged? Lock out sheet deletions or additions? Prevent changing the order of sheets? protect structure Protect Structure Property ProtectStructure ProtectStructure Property

See also: