Same behavior as header

[Alexandre Nicholas]

can we set a cell that is non selectable when you select a whole range of cells.

Headers are never selectable, the selected range stop at the limit of the headers.

Do we have to use events ?

thanks

[Administrator]

There is no property that you can set that would prevent a cell from being part of a selection.

You could handle the SelectionsChanging event, and if e.Raange contains a cell you do not want selected, then set e.Cancel = true.

You can select column headers. Mousedown on one column headers and drag over several others. You will see the headers selected at this point.