Worksheet.ProtectDrawingObjects Property

  • Article
Excel Developer Reference

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.

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

See Also