The basics:

A B C D E I have a range of cells on a worksheet
1 1 2 3 1 3 that link to 3 different lists via
2 1 2 3 1 3 data validation (e.g. All cells in
3 1 2 3 1 3 columns C and E link to list 3). I am
4 1 2 3 1 3 using the data validation/list method
5 1 2 3 1 3 to limit user input to specific valid
entries ... I don't want them typing!

The program I have developed takes them from point A to
point B using forms that direct their course depending on
how they respond to questions along the way. All cells
are locked and all worksheets are protected.

The problem:

When they get to the worksheet containing the range I
described above, my goal was, via code, to unprotect just
that worksheet, unlock just cell A1, let them pick the
appropriate value from the data validation list, once a
value greater than zero is put in cell A1 then I wanted
to relock that cell, then unlock cell B1 so they can pick
a value for that cell and so on. When a value greater
than zero is put in cell E1 I want to relock cell E1 and
reprotect the worksheet. At no time should anyone be able
to put data into any cell that is not unlocked! BUT NO!,
even with all worksheet cells locked and the worksheet
protected, my folks are able to click any cell, get the
dropdown list from data validation and select a value for
the selected cell. I DON'T UNDERSTAND. Is there a way to
prevent access to the data validation lists until a
specific cell is unlocked? Or, is there a better way to
accomplish this? Your expert guidance is needed and will
be greatly, greatly appreciated!

CTR

I couldn't reproduce that problem. When I lock the cell and protect the
sheet, then try to select from the validation drop down list, I get the
standard "sheet is protect" message and it won't let me do it. What am I
doing different than you?

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"codytheretriever" wrote in message
...
The basics:

A B C D E I have a range of cells on a worksheet
1 1 2 3 1 3 that link to 3 different lists via
2 1 2 3 1 3 data validation (e.g. All cells in
3 1 2 3 1 3 columns C and E link to list 3). I am
4 1 2 3 1 3 using the data validation/list method
5 1 2 3 1 3 to limit user input to specific valid
entries ... I don't want them typing!

The program I have developed takes them from point A to
point B using forms that direct their course depending on
how they respond to questions along the way. All cells
are locked and all worksheets are protected.

The problem:

When they get to the worksheet containing the range I
described above, my goal was, via code, to unprotect just
that worksheet, unlock just cell A1, let them pick the
appropriate value from the data validation list, once a
value greater than zero is put in cell A1 then I wanted
to relock that cell, then unlock cell B1 so they can pick
a value for that cell and so on. When a value greater
than zero is put in cell E1 I want to relock cell E1 and
reprotect the worksheet. At no time should anyone be able
to put data into any cell that is not unlocked! BUT NO!,
even with all worksheet cells locked and the worksheet
protected, my folks are able to click any cell, get the
dropdown list from data validation and select a value for
the selected cell. I DON'T UNDERSTAND. Is there a way to
prevent access to the data validation lists until a
specific cell is unlocked? Or, is there a better way to
accomplish this? Your expert guidance is needed and will
be greatly, greatly appreciated!