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 |
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 |
All times are GMT +1. The time now is 03:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com