Move cursor to specific cell after Enter whether or not data's input, in protected sheet

Hi all,

I've looked all over this board and the web and can't find the answer to this exact problem.

In a protected sheet, the unlocked cells are columns B through L. If the cursor is within columns E through L, after hitting Enter I need the cursor to move to cells in a particular column (to be exact: it needs to go one row down, column E).

I've figured out that if I do this...:

Please Login or Register  to view this content.

... I get half of the desired effect. Hitting Enter after inputting data in columns E through L takes me to the next row, column E.

However, I also need to be able to jump to the same place if I click on a cell (or tab to it) without inputting data (it may already have data, or may be blank), and hit Enter. What do I need to add / change?

The sheet's protected, some cells are locked and I can't use arrow keys or tab to get to the desired cell (the spreadsheet's been used for years, the users want "Enter", period). It has to be "hit Enter (with or without inputting data), go to row + 1, column E".

Thank you for any suggestions!

Kirk

Edit: it needs to work in Excel 2007 up to 365.

First, you have done this the hard way--your code can be simplified to this:

Please Login or Register  to view this content.

I also need to be able to jump to the same place if I click on a cell (or tab to it) without inputting data (it may already have data, or may be blank), and hit Enter.

There are two types of events that are relevant. First is the Worksheet_Change event that you already have. This will capture any time that the content of a cell is changed by the user. The other is Worksheet_SelectionChange. This will detect any time the selected cell changes. So it will detect if the user hits Enter without changing anything, because when you hit Enter, Excel moves you to another cell. It also acts if you merely tab to or click on a cell--in that case it doesn't wait for you to hit Enter. Your description says you want to do this after the user hits Enter but I suspect what you really need is to change cells if the user merely selects one of these--not really needing to hit Enter. So try this, which is exactly the same code but using SelectionChange:

Please Login or Register  to view this content.

Edit: Added red code to avoid event loop

6StringJazzer,

thank you for your reply! Looks like I'm going to have to settle on one of two work-arounds:

1) use the first code, and if someone clicks or tabs over to a cell and does nothing in it, s/he will have to "manually" go to the next cell s/he needs;

2) allow the users to Select Locked Cells under Protection; this always returns the cursor to column E after hitting Enter, whether or not data has been input. Of course that means users will be trying to type in the locked cells sometimes, and getting the error window

Thank you again!

Kirk

Correction: the first code above does NOT work properly: you can't use Tab after entering data to move to the next field to the right. Instead, you end up in column E. Basically, disregard the code.