Behind a button this would look like:

Range("A:E").Locked = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
Application.MoveAfterReturnDirection = xlToRight

But bear in mind:

You will need to unprotect via code and wont be able to by the
worksheet, so another button that had "activesheet.unprotect" would be
advised before you tried this!

Duncan


Duncan wrote:

I dont know if im reading this right but....

Can you just unlock the cells you want entry into (columns a to e would
do) and protect the worksheet stating select unlocked cells only then:
Application.MoveAfterReturnDirection = xlToRight
(or do this manually, tools, options, edit - enter direction setting)

This should surely sort it?

Let us know because im not sure if ive read it right.

Duncan


Fil wrote:

Wow... I don't know what I was thinking, I got the letters and numbers
inverted. What I ment in my previous post's exemple was :
"So for exemple, lets say the valid columns are the ones between A and E and
the current cell selected is C3. He presses enter once, it goes to D3. He
presses enter again, E3, again, A4, B4, C4, D4, E4, A5, B5... etc"
Sorry for the confusion.