Is it possible to have the Move Selection after Enter setting in Options -
Edit be set per xls file. I like the selection to move Down after Enter but
I have one file that I would like the selection to move to the Right after
Enter.
Thanks,
Marty
Is it possible to have the Move Selection after Enter setting in Options -
Edit be set per xls file. I like the selection to move Down after Enter but
I have one file that I would like the selection to move to the Right after
Enter.
Thanks,
Marty
You can use a macro to set it for this particular workbook, first create the
code
open the workbook where you want to have this happen, then do
tools>macro>record new macro
do tools>options>edit and change from the default down to right, click OK
while still recording repeat and turn move down on again, stop the macro
press alt + F11, in the left project pane look for this workbook, click the
+ sign before the folder modules, double click module1, now you should have
2 lines of code looking like
Application.MoveAfterReturnDirection = xlToRight
Application.MoveAfterReturnDirection = xlDown
copy the first line, double click ThisWorkbook, for the left dropdown select
workbook, from the right (Declarations) select open, this will give you
Private Sub Workbook_Open()
End Sub
between thos lines paste the line you copied so it will look like
Private Sub Workbook_Open()
Application.MoveAfterReturnDirection = xlToRight
End Sub
now from the dropdown to the right select BeforClose
between the 2 lines you got copy and paste the second line from the recorded
macr so it will look like
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.MoveAfterReturnDirection = xlDown
End Sub
Now right click the module form where you copied these lines and select
remove module and wehnprompted to export select no
press alt + q to close the VBE and save the workbook. Close the workbook,
now when you open this particular workbook enable macros, then it will move
to the right, but after you have closed it other workbooks will move down,
just remeber that while this workbook is open all other workbooks will go to
the right as well until you close it
Regards,
Peo Sjoblom
"Marty Leaf" wrote:
> Is it possible to have the Move Selection after Enter setting in Options -
> Edit be set per xls file. I like the selection to move Down after Enter but
> I have one file that I would like the selection to move to the Right after
> Enter.
>
> Thanks,
> Marty
>
>
>
Thank you!!!!!
Works great!!!!
"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> You can use a macro to set it for this particular workbook, first create
the
> code
> open the workbook where you want to have this happen, then do
> tools>macro>record new macro
>
> do tools>options>edit and change from the default down to right, click OK
> while still recording repeat and turn move down on again, stop the macro
> press alt + F11, in the left project pane look for this workbook, click
the
> + sign before the folder modules, double click module1, now you should
have
> 2 lines of code looking like
>
> Application.MoveAfterReturnDirection = xlToRight
> Application.MoveAfterReturnDirection = xlDown
>
> copy the first line, double click ThisWorkbook, for the left dropdown
select
> workbook, from the right (Declarations) select open, this will give you
>
> Private Sub Workbook_Open()
>
> End Sub
>
> between thos lines paste the line you copied so it will look like
>
> Private Sub Workbook_Open()
> Application.MoveAfterReturnDirection = xlToRight
> End Sub
>
> now from the dropdown to the right select BeforClose
>
> between the 2 lines you got copy and paste the second line from the
recorded
> macr so it will look like
>
> Private Sub Workbook_BeforeClose(Cancel As Boolean)
> Application.MoveAfterReturnDirection = xlDown
> End Sub
>
> Now right click the module form where you copied these lines and select
> remove module and wehnprompted to export select no
>
> press alt + q to close the VBE and save the workbook. Close the workbook,
> now when you open this particular workbook enable macros, then it will
move
> to the right, but after you have closed it other workbooks will move down,
> just remeber that while this workbook is open all other workbooks will go
to
> the right as well until you close it
>
> Regards,
>
> Peo Sjoblom
>
>
> "Marty Leaf" wrote:
>
> > Is it possible to have the Move Selection after Enter setting in
Options -
> > Edit be set per xls file. I like the selection to move Down after Enter
but
> > I have one file that I would like the selection to move to the Right
after
> > Enter.
> >
> > Thanks,
> > Marty
> >
> >
> >
Thanks for the thank you
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Marty Leaf" <[email protected]> wrote in message
news:[email protected]...
> Thank you!!!!!
> Works great!!!!
>
> "Peo Sjoblom" <[email protected]> wrote in message
> news:[email protected]...
>> You can use a macro to set it for this particular workbook, first create
> the
>> code
>> open the workbook where you want to have this happen, then do
>> tools>macro>record new macro
>>
>> do tools>options>edit and change from the default down to right, click OK
>> while still recording repeat and turn move down on again, stop the macro
>> press alt + F11, in the left project pane look for this workbook, click
> the
>> + sign before the folder modules, double click module1, now you should
> have
>> 2 lines of code looking like
>>
>> Application.MoveAfterReturnDirection = xlToRight
>> Application.MoveAfterReturnDirection = xlDown
>>
>> copy the first line, double click ThisWorkbook, for the left dropdown
> select
>> workbook, from the right (Declarations) select open, this will give you
>>
>> Private Sub Workbook_Open()
>>
>> End Sub
>>
>> between thos lines paste the line you copied so it will look like
>>
>> Private Sub Workbook_Open()
>> Application.MoveAfterReturnDirection = xlToRight
>> End Sub
>>
>> now from the dropdown to the right select BeforClose
>>
>> between the 2 lines you got copy and paste the second line from the
> recorded
>> macr so it will look like
>>
>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>> Application.MoveAfterReturnDirection = xlDown
>> End Sub
>>
>> Now right click the module form where you copied these lines and select
>> remove module and wehnprompted to export select no
>>
>> press alt + q to close the VBE and save the workbook. Close the workbook,
>> now when you open this particular workbook enable macros, then it will
> move
>> to the right, but after you have closed it other workbooks will move
>> down,
>> just remeber that while this workbook is open all other workbooks will go
> to
>> the right as well until you close it
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>> "Marty Leaf" wrote:
>>
>> > Is it possible to have the Move Selection after Enter setting in
> Options -
>> > Edit be set per xls file. I like the selection to move Down after Enter
> but
>> > I have one file that I would like the selection to move to the Right
> after
>> > Enter.
>> >
>> > Thanks,
>> > Marty
>> >
>> >
>> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks