ControlFormat.LockedText property (Excel)

True if the text in the specified object will be locked to prevent changes when the workbook is protected. Read/write Boolean.

Syntax

expression.LockedText

expression A variable that represents a ControlFormat object.

Example

This example locks text in embedded chart one when the workbook is protected.

Worksheets(1).ChartObjects(1).LockedText = True

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.