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

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 ?

When the cells are being protected using Tools,Protection, Protect Sheet,
de-select the tick box in the allow users to select area for the Locked
Cells Option.

Remember that by default, all cells in Excel are Locked.

--

Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"Howman" wrote in message
...
How do you stop protected cells from being selected on a worksheet in
excel ?

I have seen that as an option in Excel 2003, but is it possible in earlier
versions of Excel without using VBA?

Dan

"Saruman" wrote:

When the cells are being protected using Tools,Protection, Protect Sheet,
de-select the tick box in the allow users to select area for the Locked
Cells Option.

Remember that by default, all cells in Excel are Locked.

--

Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"Howman" wrote in message
...
How do you stop protected cells from being selected on a worksheet in
excel ?