Worksheet.ProtectionMode Property

Excel Developer Reference

True if user-interface-only protection is turned on. To turn on user interface protection, use the Protect method with the UserInterfaceOnly argument set to True. Read-only Boolean.

Syntax

expression.ProtectionMode

expression   A variable that represents a Worksheet object.

Example

This example displays the status of the ProtectionMode property.

Visual Basic for Applications
MsgBox ActiveSheet.ProtectionMode

See Also

• Worksheet Object
• Worksheet Object Members