(Msg. 1) Posted: Tue Jan 01, 2008 9:13 pm
Post subject: Default movement of cursor Archived from groups: microsoft>public>excel>templates (more info?)
When I change the direction of the cursor when pressing enter in a
worksheet, is there any way to change/save this command for indiviual
worksheets, rather than a global change?
(Msg. 2) Posted: Tue Jan 01, 2008 10:07 pm
Post subject: Re: Default movement of cursor [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not without some event code which changes the option when you
activate/deactivate certain sheets.
Private Sub Worksheet_Activate()
Application.MoveAfterReturnDirection = xlToRight
End Sub
Private Sub Worksheet_Deactivate()
Application.MoveAfterReturnDirection = xlDown
End Sub
This is sheet event code. Right-click on the sheet tab and "View Code".
Copy/paste into that sheet module.
Gord Dibben MS Excel MVP
On Tue, 1 Jan 2008 21:13:04 -0600, "TIPPA" <pmurden RemoveThis @rtconline.com> wrote:
>When I change the direction of the cursor when pressing enter in a
>worksheet, is there any way to change/save this command for indiviual
>worksheets, rather than a global change?
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office