Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Scroll Area
How do you set the Scroll Area on a worksheet so that the ability to move
around the sheet is limited to the selected area? |
#2
|
|||
|
|||
Hide all other rows and/or columns.
************ Anne Troy www.OfficeArticles.com "Paul Dusterhoft" wrote in message ... How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#3
|
|||
|
|||
Paul
Hiding the unused rows and columns then protecting the sheet is the usual method. Setting the scrollarea using VBA is another method. Note: Setting ScrollArea is good for that session only and only the activesheet. Has to be reset next time workbook is opened. Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and specify which worksheet. Private Sub WorkBook_Open() Sheets("YourSheet").ScrollArea = "A1:P60" End Sub Gord Dibben Excel MVP On Tue, 20 Sep 2005 20:17:47 GMT, "Paul Dusterhoft" wrote: How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#4
|
|||
|
|||
You can also
Right-Click on your sheet-tab Select View Code If Properties Window is not shown press F4 In Properties Window, near bottom you'll see Scroll Area - In blank box to right enter desired Range, say B2:G20 Exit out of VBE Done "Paul Dusterhoft" wrote in message ... How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#5
|
|||
|
|||
Good tip Jim but this method is also lost when you close the workbook.
Has to be reset when re-opened, hence my Workbook_Open code. Gord On Tue, 20 Sep 2005 19:06:14 -0400, "Jim May" wrote: You can also Right-Click on your sheet-tab Select View Code If Properties Window is not shown press F4 In Properties Window, near bottom you'll see Scroll Area - In blank box to right enter desired Range, say B2:G20 Exit out of VBE Done "Paul Dusterhoft" wrote in message ... How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#6
|
|||
|
|||
Wasn't aware of this feature (?). LOL
Thanks, Jim "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Good tip Jim but this method is also lost when you close the workbook. Has to be reset when re-opened, hence my Workbook_Open code. Gord On Tue, 20 Sep 2005 19:06:14 -0400, "Jim May" wrote: You can also Right-Click on your sheet-tab Select View Code If Properties Window is not shown press F4 In Properties Window, near bottom you'll see Scroll Area - In blank box to right enter desired Range, say B2:G20 Exit out of VBE Done "Paul Dusterhoft" wrote in message ... How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#7
|
|||
|
|||
Hi Paul
Right click on the worksheet Tab and choose View Code. If the Properties window is not visible, press F4. In Scroll Area, set the range of the area you require. Regards Roger Govier Paul Dusterhoft wrote: How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#8
|
|||
|
|||
But even after saving the Workbook;
Your Scroll Area is Lost; See Gord's reply to my suggestion above.. Jim "Roger Govier" wrote in message ... Hi Paul Right click on the worksheet Tab and choose View Code. If the Properties window is not visible, press F4. In Scroll Area, set the range of the area you require. Regards Roger Govier Paul Dusterhoft wrote: How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
#9
|
|||
|
|||
Hi Jim
Thanks for the heads up! I had not seen either your, or Gordon's post on my system when I posted my response. I equally was unaware that the setting didn't "stick" on saving. In all cases where I use the technique to prevent users accessing parts of the sheet, I set it via code in the workbook open event, but thought that a manual setting would also work and be a simpler answer for the OP. Thank goodness we never stop learning!!! Regards Roger Govier Jim May wrote: But even after saving the Workbook; Your Scroll Area is Lost; See Gord's reply to my suggestion above.. Jim "Roger Govier" wrote in message ... Hi Paul Right click on the worksheet Tab and choose View Code. If the Properties window is not visible, press F4. In Scroll Area, set the range of the area you require. Regards Roger Govier Paul Dusterhoft wrote: How do you set the Scroll Area on a worksheet so that the ability to move around the sheet is limited to the selected area? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
Restrict Scroll Area | Excel Discussion (Misc queries) | |||
Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) | |||
Worksheet scroll area | Excel Discussion (Misc queries) | |||
Worksheet Scroll Area | Excel Discussion (Misc queries) |