| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll Limit
Hi...
On several sheets I don't want users to scroll beyond A1:Q61. Can this be done? Thanks Gordon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Scroll Limit
Use ScrollArea property of worksheet
For example Sheet1.ScrollArea="A1:Q61" -- Haldun Alay "Gordon" , haber iletisinde þunlarý ... Hi... On several sheets I don't want users to scroll beyond A1:Q61. Can this be done? Thanks Gordon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Scroll Limit
Hi...
Apologies for being dim...where would this code live? "Haldun Alay" wrote: Use ScrollArea property of worksheet For example Sheet1.ScrollArea="A1:Q61" -- Haldun Alay "Gordon" , haber iletisinde þunlarý ... Hi... On several sheets I don't want users to scroll beyond A1:Q61. Can this be done? Thanks Gordon |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Scroll Limit
Probably the best bet would be in the workbook open event. Right click on the
XL icon next to File in the menu bar and select view code. Add something like this... Private Sub Workbook_Open() Sheet1.ScrollArea = "A1:Q61" End Sub -- HTH... Jim Thomlinson "Gordon" wrote: Hi... Apologies for being dim...where would this code live? "Haldun Alay" wrote: Use ScrollArea property of worksheet For example Sheet1.ScrollArea="A1:Q61" -- Haldun Alay "Gordon" , haber iletisinde þunlarý ... Hi... On several sheets I don't want users to scroll beyond A1:Q61. Can this be done? Thanks Gordon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limit the scroll of a worksheet | Excel Discussion (Misc queries) | |||
| limit scroll area of split window panes? | Excel Programming | |||
| Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
| How do I limit the vertical scroll? | Setting up and Configuration of Excel | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
