Force a carriage return in a protected worksheet

[jimboryan]

I'm not sure why but in the attached spreadsheet pressing enter does not put you at the first cell in the row below the one you're in. I think it's because I've protected the worksheet to prevent people from putting info in the wrong cells. Is there a way to make Enter drop to the first cell of the next row down, or a way to make TAB move you to the first cell of the row below after a certain column? In the attached spreadsheet we fill in four rows of data starting at B10. After U10 you go to B11. Currently the only way to get there is to move the cursor and click in B11. I would like it automated if possible.

Thanks!

[LJMetzger]

Hi jimboryan,

There are two things I can think of that you can do:
a. I don't think you are protecting the cells correctly.
(1) Unprotect the sheet
(2) Click the box between the 'A' and the '1' and Protect the entire worksheet.
(3) Unprotect your data entry cells as required.
(4) Protect the Sheet.

Now when data entry is done in U10, the focus will be on 'B11'

b. Use a Worksheet_Change() Event. When a cell changes value, Select the Cell that you want the focus to move to:
Simple Example:

Please Login or Register  to view this content.

I hope this helps.

Lewis

[jimboryan]

The first method did exactly what I was hoping for. However, I think I will play with the other solution as well.

Thank you very much!