Export (0) Print
Expand All

Worksheet.ProtectDrawingObjects Property

Office 2007
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



Community Additions

ADD
Show:
© 2015 Microsoft