change keyboard responses in excel

[thehudd]

I have a protected worksheet. To get around in the worksheet I need to use the tab key. The people that use the spread sheet always hit the "enter" key, which drop down one cell. I would like to change the "enter" key response to "tab" on open. It must be through ascii but I cannot figure it out. I sure can use your help.

 

[Mark O'Brien]

It must be through ascii but I cannot figure it out. I sure can use your help.

I don't understand what you mean by "It must be through ascii", but you can change the direction of the cursor when you hit "ENTER" by going to Tools|Option|Edit TAB and make sure the "Move Direction After Enter" box is checked, then change the "Direction" dropdown box to "Right"

HTH

 

[lenze]

Say the fields they enter in are $A$1 $C$1 $E$1 $A$4 $B$6 in that order. This code will move the selection to the next fieldwhen Enter is keyed
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address=(“$A$1”) Then Range(“$C$1”).Select
If Target.Address=("$C$1”) Then Range(“$E$1”).Select
etc.



End Sub

 

[Ivan F Moala]

If you must change it then lookup online
help for OnKey....you can change the enter
key to Tab using code.

 

[Legacy 98055]

see:

http://www.mrexcel.com/board/viewtopic.php?topic=5982&forum=2

Should give you what you need

Tom