Worksheet.ProtectDrawingObjects Property (Excel)

True if shapes are protected. To turn on shape protection, use the Protect method with the DrawingObjects argument set to True. Read-only Boolean.

Syntax

expression .ProtectDrawingObjects

expression A variable that represents a Worksheet object.

Example

This example displays a message box if the shapes on Sheet1 are protected.

If Worksheets("Sheet1").ProtectDrawingObjects = True Then 
 MsgBox "The shapes on Sheet1 are protected." 
End If

請參閱

概念

Worksheet Object

Worksheet Object Members