Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Enter key movement in one workbook only
Oh Wise Ones,
On all but one of my workbooks I need the cursor to move to the right after pressing Enter on the numeric keypad to save inputted data. On one sheet I would like it to move down on Enter. Is there a way for excel to recognize and change the movement on one sheet, but behave normally (according to the options setting) in other workbooks automatically? Thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Enter key movement in one workbook only
Put the following code in the ThisWorkbook code module of the workbook in
which you want the direction to be down. Option Explicit Private MoveDir As XlDirection Private Sub Workbook_Activate() MoveDir = Application.MoveAfterReturnDirection Application.MoveAfterReturnDirection = xlDown End Sub Private Sub Workbook_Deactivate() If MoveDir = 0 Then MoveDir = xlToRight End If Application.MoveAfterReturnDirection = MoveDir End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Mike K" wrote in message ... Oh Wise Ones, On all but one of my workbooks I need the cursor to move to the right after pressing Enter on the numeric keypad to save inputted data. On one sheet I would like it to move down on Enter. Is there a way for excel to recognize and change the movement on one sheet, but behave normally (according to the options setting) in other workbooks automatically? Thanks, Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Enter key movement in one workbook only
Thanks Chip!
"Chip Pearson" wrote: Put the following code in the ThisWorkbook code module of the workbook in which you want the direction to be down. Option Explicit Private MoveDir As XlDirection Private Sub Workbook_Activate() MoveDir = Application.MoveAfterReturnDirection Application.MoveAfterReturnDirection = xlDown End Sub Private Sub Workbook_Deactivate() If MoveDir = 0 Then MoveDir = xlToRight End If Application.MoveAfterReturnDirection = MoveDir End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Mike K" wrote in message ... Oh Wise Ones, On all but one of my workbooks I need the cursor to move to the right after pressing Enter on the numeric keypad to save inputted data. On one sheet I would like it to move down on Enter. Is there a way for excel to recognize and change the movement on one sheet, but behave normally (according to the options setting) in other workbooks automatically? Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter on value in one worksheet display in whole workbook | New Users to Excel | |||
Customize cursor movement when pressing enter | Excel Discussion (Misc queries) | |||
how do i set the enter key to give a horizontal movement | Excel Worksheet Functions | |||
Enter key movement direction | Setting up and Configuration of Excel | |||
change 'alt+enter' combo to just 'enter' | Excel Discussion (Misc queries) |