MoveAfterReturnDirection

[V. Roe]

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

 

[Bob Phillips]

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]

Thank you, I was able to get it working.

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)