This post will guide you how to define a scroll area to a specific range in your worksheet in Excel. How to limit the scroll area for a worksheet via VBA macro in Excel.

1. Define a Scroll Area

If you want to define a scroll range in your current worksheet, you just need to set Scroll Area properties in VBA application window. Just do the following steps:

Step1: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Step2: then the “Visual Basic Editor” window will appear.

Step3: click View menu in VBA window, and select Properties Window to show Properties pane.

Step4: locate Scroll Area property and enter the range that you want to limit the worksheet to. Such as: $A$30:$C$45

Step5: press Enter key on your keyboard, and then Close the Properties.     

2. Limit Scroll Area via VBA macro

You can also use VBA Macro to define a scroll area for a particular worksheet, for example, if you want to set the scroll area A30:C45 on Sheet3, you can do the following steps:

Step1: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Step2: then the “Visual Basic Editor” window will appear.

Step3: click “Insert” ->”Module” to create a new module.

Step4: paste the below VBA code  into the code window. Then clicking “Save” button.

Sub LimitScrollArea()
   Sheets("Sheet1").ScrollArea = "A30:C45 "
End Sub

Step5: back to the current worksheet, then run the above excel macro. Click Run button.

3. Video: Limit Scroll Area

This video tutorial will show you how to define a scroll area to a specific range in your worksheet throught VBA Macro in Excel.

https://youtu.be/iaDCJWGFtMQ