Edit

Share via

DisplayFormat.Locked property (Excel)

  • Article

Returns a value that indicates if the associated Range object is locked as it is displayed in the current user interface. Read-only.

Syntax

expression.Locked

expression A variable that represents a DisplayFormat object.

Return value

Variant

Remarks

Returns True if the range is locked, False if the range can be modified when the sheet is protected, or Null if the range contains both locked and unlocked cells.

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.