HotXLS Docs

Locked property

True if the range is locked, False if the range can be modified when the sheet is protected. Read/write Boolean. Default value is True.

Syntax

property Locked: Boolean;

Example

This example unlocks cells B5:F30 on sheet one so that they can be modified when the sheet is protected.

Workbook.Sheets[1].Range['B5','F30'].Locked := false;
Workbook.Sheets[1].Protect;