I have certain rows with data validation drop boxes in them with locked rows
in-between. Is there a way to get the cursor to move to the next row with a
data validation box in it once they hit enter or arrow down and skip the rows
in-between?

If the sheet protected and the entry cells are unlocked, the Tab key will
complete the entry and move the cell pointer to the next unlocked cell;
moving first to the right then down similar to a caridge return. It will
skip over all locked cells.
If the sheet is unprotected or you have unlocked cells you wish to skip
over, you may need to use VB code or a User Form.

Regards,
Dave

"bill007" wrote in message
...
I have certain rows with data validation drop boxes in them with locked
rows
in-between. Is there a way to get the cursor to move to the next row with
a
data validation box in it once they hit enter or arrow down and skip the
rows
in-between?