Disabling the Enter Key

[Ernie Fenwick]

Hi
I have a form with several unlocked cells, some of which are horizontal to each other and others directly below. Navigating through with the Tab key is ideal, but the Enter key will drop down a row rather than tab to the next field. I would like to disable the Enter key to prevent users from being able to do that.

I have the following codes at ThisWorkbook level

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I find that when I enter data into a cell and press the enter key nothing happens, but if I press the enter key again then cursor moves to the next cell down.
All of the cells in my worksheet are locked except the following (some of which are merged)
E6, E8, D15, F15, D22, F22, D35, F35, D41, F41, D47, F47, D57, F57, D67, F67, D79, D90, E94, G94, and I want to tab through them in that order.

Any ideas anyone please?
Ernie

[cubangt]

Give this try:

Please Login or Register  to view this content.

to turn it back on

Please Login or Register  to view this content.

Found here:
https://www.mrexcel.com/board/thread...running.77758/

[Ernie Fenwick]

Thanks cubangt
also adding a msbox "Please use Tab between cells" in the first routine works just fine. I haven't yet worked out how the second sub works when it has the same name.
Regards
Ernie

[cubangt]

Should work by changing the name, i didnt realize when i copied it..i think all that matters is the logic within, call it within your logic as needed.