ProtectContents Property [Excel 2003 VBA Language Reference]
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. To turn on content protection, use the Protect method with the Contents argument set to True. Read-only Boolean.
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
Applies to | Chart Object | Worksheet Object
See Also | Locked Property | Protect Method | ProtectWindows Property | Unprotect Method