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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.