Pressing Enter Key

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yo - 28 Oct 2005 16:28 GMT

Hi,

I would like to press the Enter key and have it move Right instead of Down
on one of my excel spreadsheets. I know you can change that option under
tools, but that changes it for every workbook, and I only want that option
on a certain workbook. Is there a way I can make this happen without
changing it everytime I open Excel?

Thanks in advance for your advice.

Reply to this Message

Dave Peterson - 28 Oct 2005 18:23 GMT

Record a macro when you change this setting to right.
Put that code in the workbook_activate event

Record a macro when you change this setting back to down.
Put that code in the workbook_deactivate event.

Both of these events go behind the ThisWorkbook module.

This is what my code looked like:

Option Explicit
Private Sub Workbook_Activate()
Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlToRight
End Sub
Private Sub Workbook_Deactivate()
Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlDown
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance for your advice.

Signature

Dave Peterson

Reply to this Message

Yo - 28 Oct 2005 19:13 GMT

Worked Perfectly, Thank You!!

> Record a macro when you change this setting to right.
> Put that code in the workbook_activate event
[quoted text clipped - 30 lines]
>>
>> Thanks in advance for your advice.

Reply to this Message

David McRitchie - 28 Oct 2005 22:27 GMT

In this case my event.htm page would be better than my getstarted.htm page.

Specifically for workbook macros which get installed in
ThisWorkbook the shortcut would be:
RightClick on the Excel logo to left of file menu, then use "View Code"

To get to know event macros better see
http://www.mvps.org/dmcritchie/excel/event.htm
and workbook event macros material begin at
http://www.mvps.org/dmcritchie/excel/event.htm#blueboxWB
---
HTH,
David McRitchie
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message

> Both of these events go behind the ThisWorkbook module.
> [clipped...]
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm

Reply to this Message

Dave Peterson - 28 Oct 2005 22:59 GMT

I was hoping that with the combination of ThisWorkbook module and your
getstarted page (if the OP had never seen macros) would be sufficient.

But I agree that your event page should have been included. In fact, here's my
standard cut and paste for events:

There are lots of these worksheet/workbook events that you can tie into. Here's
a couple of links that you may want to bookmark:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

======
But I got lazy....

> In this case my event.htm page would be better than my getstarted.htm page.
>
[quoted text clipped - 17 lines]
> > If you're new to macros, you may want to read David McRitchie's intro at:
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm

Signature

Dave Peterson

Reply to this Message