Excel.Workbook.ProtectStructure.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.ProtectStructure property (Excel)	vbaxl10.chm199131	vbaxl10.chm199131	Excel.Workbook.ProtectStructure	bf721b60-0ad1-f71c-7ef4-74d2196d320e	05/29/2019	medium

Workbook.ProtectStructure property (Excel)

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.

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

[!includeSupport and feedback]