Thank you, I was able to get it working.

"Bob Phillips" wrote in message
...
Hi Valerie,

Do you mean the after return action? If so, you can get that from

Application.MoveAfterReturnDirection

--

HTH

RP
(remove nothere from the email address if mailing direct)


"V. Roe" wrote in message
...
I am using Excel 97, but the application I am writing will be used on
97,
2000 & 2002.
I need to make sure that when the workbook is opened the enter key moves
the
cursor to the right.
I have no problem changing to xlToRight when the workbook opens, but I
would
like to be able to set it back to the users original direction. Is it
possible to trap the current direction so that I can change it and then
reset on close of workbook?
Any help would be much appreciated.
Valerie