ProtectionMode Property

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.

Example

This example displays the status of the ProtectionMode property.

MsgBox ActiveSheet.ProtectionMode