E
eas1511
I have created a spreadsheet which mimics a financial paper form for one of
my users.
Most cells on the spreadsheet are locked, with only those that the user
needs to enter unlocked. I protect the spreadsheet, allowing only unlocked
cells to be selected.
The form is saved as a template, and the user opens a new file using the
template for each case.
When I test the form, the active cell moves across each row of the form from
left to right when I hit ENTER. When it gets to the rightmost unlocked cell
in the row, Enter takes the active cell to the leftmost available cell in
the next row down, and then proceeds across the row.
BUT, when I put the template onto my user's PC, movement of the active cell
becomes eccentric. Sometimes it behaves as above, sometimes it moves down to
the cell below. At the rightmost column, the active cell szxometimes jumps
up to the first unlocked cell on the spreadsheet (B3).
I have included
With Application
.MoveAfterReturn = True
.MoveAfterReturnDirection = xlToRight
End With
In the code which opens that spreadsheet (the user navigates thru the
workbook using command buttons)
This is HUGELY frustrating me (and the user). The real annoyance is that
the form worked fine for over a year. I opened the workbook to make a
cosmetic change, and it started this behaviour.
I wonder if there is an Excel configuration setting somewhere I have missed?
my users.
Most cells on the spreadsheet are locked, with only those that the user
needs to enter unlocked. I protect the spreadsheet, allowing only unlocked
cells to be selected.
The form is saved as a template, and the user opens a new file using the
template for each case.
When I test the form, the active cell moves across each row of the form from
left to right when I hit ENTER. When it gets to the rightmost unlocked cell
in the row, Enter takes the active cell to the leftmost available cell in
the next row down, and then proceeds across the row.
BUT, when I put the template onto my user's PC, movement of the active cell
becomes eccentric. Sometimes it behaves as above, sometimes it moves down to
the cell below. At the rightmost column, the active cell szxometimes jumps
up to the first unlocked cell on the spreadsheet (B3).
I have included
With Application
.MoveAfterReturn = True
.MoveAfterReturnDirection = xlToRight
End With
In the code which opens that spreadsheet (the user navigates thru the
workbook using command buttons)
This is HUGELY frustrating me (and the user). The real annoyance is that
the form worked fine for over a year. I opened the workbook to make a
cosmetic change, and it started this behaviour.
I wonder if there is an Excel configuration setting somewhere I have missed?