Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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~~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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~~ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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~~ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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~~ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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~~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|