STOPPER
 

I'm looking to see if I can stop the arrow from going on....
Example my end of the page is L1 down to L23 but it I push the right arrow
when in column "L" it wiil continue to go over M, N, O, P.... and so on... is
there a way to stop the cursing form gone further when not needed... reply if
you can help

--
~~Bugzie~~

STOPPER
 

How about just hiding all the unneeded columns

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Bugzie" wrote in message
...
I'm looking to see if I can stop the arrow from going on....
Example my end of the page is L1 down to L23 but it I push the right
arrow
when in column "L" it wiil continue to go over M, N, O, P.... and so on...
is
there a way to stop the cursing form gone further when not needed... reply
if
you can help

--
~~Bugzie~~

STOPPER
 

thanks for the quick reply, but I'm new to this.... how do I HIDE the
unwanted colums/rows
--
~~Bugzie~~


"Ken Wright" wrote:

How about just hiding all the unneeded columns

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"Bugzie" wrote in message
...
I'm looking to see if I can stop the arrow from going on....
Example my end of the page is L1 down to L23 but it I push the right
arrow
when in column "L" it wiil continue to go over M, N, O, P.... and so on...
is
there a way to stop the cursing form gone further when not needed... reply
if
you can help

--
~~Bugzie~~

STOPPER
 

Hi Bugzie

One way is to set the Scroll Area for the sheet.
If this is only on a temporary basis, then right click on the Sheet tab
and chose View Code.
In the VBE, if the Properties window is not visible, press F4.
In the Properties window, you will see Scroll Area, enter the desired
range A1:L23 in that filed and press the Excel icon to return to your
sheet.

If you want to remove the lock, then go back to the properties and clear
the scroll area field.

On closing the file, it will get cleared automatically.

If you want it to happen each time you open the file, then add the
following code to the Workbook module.
Again, in the VB Editor, if the Project Explorer isn't visible, type
Ctrl+R to bring it up. Navigate to This Workbook and double click on the
icon. then copy the code below into the white pane at the top right of
the screen.

Private Sub Workbook_Open()

ThisWorkbook.Worksheets("Sheet1").ScrollArea = "A1:L23"

End Sub

Change "Sheet1" to whatever your sheet is called.
You will be prevented from doing certain things whilst scroll area is in
place, e.g inserting rows or columns, but simply remove the lock to go
back to normal.


--
Regards

Roger Govier


"Bugzie" wrote in message
...
I'm looking to see if I can stop the arrow from going on....
Example my end of the page is L1 down to L23 but it I push the right
arrow
when in column "L" it wiil continue to go over M, N, O, P.... and so
on... is
there a way to stop the cursing form gone further when not needed...
reply if
you can help

--
~~Bugzie~~

STOPPER
 

Select columns M onwards by clicking on the top of Col M, holding down SHIFT
and then pressing CTRL and RIGHT arrow. Then do Format / Columns / Hide.

Regards
Ken....................

"Bugzie" wrote in message
...
thanks for the quick reply, but I'm new to this.... how do I HIDE the
unwanted colums/rows
--
~~Bugzie~~


"Ken Wright" wrote:

How about just hiding all the unneeded columns

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Bugzie" wrote in message
...
I'm looking to see if I can stop the arrow from going on....
Example my end of the page is L1 down to L23 but it I push the right
arrow
when in column "L" it wiil continue to go over M, N, O, P.... and so
on...
is
there a way to stop the cursing form gone further when not needed...
reply
if
you can help

--
~~Bugzie~~