Cursor position after enter

[Guest]

I have found how to set the after enter behaviour of the cursor in the
options menu.

What I want to do is have the cursor jump to the next (unlocked cell right
and then down)

Or another way to say it is... DataEntryCells = (B2,B4,B6:E6,B7,B9:E9,B10...)
This range of cells will be the "Allow User to Edit range"
I could also make this a named range if need be...

How can I make the enter button cause tabbing to just these cells? When at
the bottom.. then return to the top.

Either with just excel features or through some kind of on cell activate
event... what are my options here?

 

[Guest]

Hi,
Not 100% sure but:
-In XL 2002 and above, sheet the sheet EnableSelection to xlUnlockedCells
and protect your sheet.
-In XL 2K, if you do the same thing, once you close and re-open the book,
the property has been re-set (i believe). That is, you have to set it through
code in the ThisWorkbook module in the Workbook_Open sub:
Private Sub Workbook_Open()
Me.Worksheets("Sheet1").EnableSelection = xlUnlockedCells
End Sub

 

[Guest]

Excellent, that worked.

I had to go to the Format|Cells|ProtectionTab and uncheck locked on each
cell/range I wanted to be in the editable list.

Enter or tab now activates the next cell in the sequence that I wanted.

 

[Guest]

Hi John and Sebastian,

I too would like to automate cursor movement. I can't work out what the
instructions you have given mean. I've typed in "Sheet Enable", Enable
Selection", and "Xlunlocked cells" into help but nothing of any help comes up.

What I'd like to do is to somehow set the cell itself to send the cursor to
a specific cell on "Enter". Is there a way? I'm using Excel 2000 by the way.

It'd be great - and elementary - tool almost EVERYONE would probably use if
Microsoft would place that option (both absolute and relative) on the "format
cell" menu.