Worksheet.ProtectContents Property

  • Article
Excel Developer Reference

True if the contents of the sheet are protected. This protects the individual cells. To turn on content protection, use the Protect method with the Contents argument set to True. Read-only Boolean.

Syntax

expression.ProtectContents

expression   A variable that represents a Worksheet object.

Example

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

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

See Also