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

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"John Keith" wrote:

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?

--
Regards,
John