Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activesheet.Scrollarea
I'm using Excel 97. Is it possible to use Activesheet.Scrollarea on
several non-contiguous ranges? For example, restrict the user to A1:A10, B50:C100, and D25:D100? Note: Unfortunately I can't protect the worksheet and use Worksheets("Sheet1").EnableSelection = xlUnlockedCells |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activesheet.Scrollarea
try this assigned to a button or shape
(also sent privately in case server screw up) Sub multiscroll() With ActiveSheet Select Case InputBox("select area 1,2,or 3 ONLY") Case 1 ..ScrollArea = "a1:a10" Case 2 ..ScrollArea = "b50:c100" Case 3 ..ScrollArea = "d25:d100" Case Else ..ScrollArea = "a1:a1" End Select End With End Sub "R. Todd Miller" wrote in message om... I'm using Excel 97. Is it possible to use Activesheet.Scrollarea on several non-contiguous ranges? For example, restrict the user to A1:A10, B50:C100, and D25:D100? Note: Unfortunately I can't protect the worksheet and use Worksheets("Sheet1").EnableSelection = xlUnlockedCells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit Scrollarea | Excel Worksheet Functions | |||
ScrollArea | Excel Discussion (Misc queries) | |||
Scrollarea | Excel Discussion (Misc queries) | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming |