If you use VBA, you can set the enableselection property for the cells.

For instance:
Sheet1.EnableSelection = xlUnlockedCells

This will allow selection in only the unlocked cells.

Dan

"Howman" wrote:

How do you stop protected cells from being selected on a worksheet in excel ?