ProtectContents Property

Applies To

Chart object, Worksheet object.

Description

True if the contents of the sheet are protected. For a chart, this protects the entire chart. For a worksheet, this protects the individual cells. Read-only Boolean.

See Also

Locked property, Protect method, ProtectWindows property, Unprotect method.

Example

This example displays a message box if the contents of Sheet1 are protected.

If Worksheets("Sheet1").ProtectContents = True Then
    MsgBox "The contents of Sheet1 are protected."
End If