EnableSelection Property

See Also         Example         Applies To

Returns or sets what can be selected on the sheet. Can be one of the following XlEnableSelection constants: xlNoRestrictions, xlNoSelection, or xlUnlockedCells. Read/write Long.

Remarks

This property takes effect only when the worksheet is protected: xlNoSelection prevents any selection on the sheet, xlUnlockedCells allows only those cells whose Locked property is False to be selected, and xlNoRestrictions allows any cell to be selected.