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