Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing scroll outside active area
Is there a way of preventing a user from scrolling left and right outside of
the screen area WITHOUT resorting to hiding the colums on either side. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing scroll outside active area
from vba help index for scroll and you would see scroolarea directly
underneath. Must be set from a workbook_open event each time workbook is opened. ScrollArea Property See Also Applies To Example Specifics Returns or sets the range where scrolling is allowed, as an A1-style range reference. Cells outside the scroll area cannot be selected. Read/write String. Remarks Set this property to the empty string ("") to enable cell selection for the entire sheet. Example This example sets the scroll area for worksheet one. Worksheets(1).ScrollArea = "a1:f10" -- Don Guillett SalesAid Software "Ben" wrote in message ... Is there a way of preventing a user from scrolling left and right outside of the screen area WITHOUT resorting to hiding the colums on either side. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing scroll outside active area
Ben
Through VBA Since the scrollarea method does not stick between sessions you will have to reset it each time. You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module and specify which worksheet if only one sheet required. Private Sub WorkBook_Open() Sheets("YourSheet").ScrollArea = "A1:T30" End Sub Or also in the Thisworkbook module to limit scrollarea on all sheets. Private Sub Workbook_SheetActivate(ByVal Sh As Object) With ActiveSheet .ScrollArea = "A1:T30" End With End Sub Gord Dibben MS Excel MVP On Sun, 29 Oct 2006 08:59:01 -0800, Ben wrote: Is there a way of preventing a user from scrolling left and right outside of the screen area WITHOUT resorting to hiding the colums on either side. Thank you Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separate scroll bars for each area of split screen | Excel Discussion (Misc queries) | |||
Restricting Scroll Area | Excel Discussion (Misc queries) | |||
how to scroll through active cells instead of entire worksheet | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
Worksheet scroll area | Excel Discussion (Misc queries) |