Hi,

I have a feeling that this is really easy, but I'm not sure exactly how to proceed.

For a single Excel file, I would like to disable "Move Selection After Enter" (see Tools>Options>Edit tab). However, I want this to be in effect for this one file only, and I would like all other open Excel files to be unaffected.

Is there a way to do this?

Thanks!
-Mike

Hi Mike

If you put the code

Application.MoveAfterReturn = False

Into the Workbook_Open Event and the Workbook_Activate Event
And then put

Application.MoveAfterReturn = True

Into the Workbook_BeforeClose and Workbook_Deactivate Events
This should let you restrict the behaviour to the one workbook

HTH
David

Thanks! It works great!