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