Worksheet.ProtectionMode Property (Excel)
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.
MsgBox ActiveSheet.ProtectionMode