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.

expression .ProtectionMode

expression A variable that represents a Worksheet object.

This example displays the status of the ProtectionMode property.

MsgBox ActiveSheet.ProtectionMode
© 2015 Microsoft