Skipping Rows with cursor



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


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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question