Range.Locked property (Excel)
Returns or sets a Variant value that indicates if the object is locked.
expression A variable that represents a Range object.
This property returns True if the object is locked, False if the object can be modified when the sheet is protected, or Null if the specified range contains both locked and unlocked cells.
This example unlocks cells A1:G37 on Sheet1 so that they can be modified when the sheet is protected.
Worksheets("Sheet1").Range("A1:G37").Locked = False Worksheets("Sheet1").Protect
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.