How to Limit Scroll Area in Excel

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.

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.

Get the position of the nth using excel vba1

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

limit scroll area3

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

limit scroll area1

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

limit scroll area2

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

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.
Get the position of the nth using excel vba1

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

Step3: click “Insert” ->”Module” to create a new module.
export each sheet to csv2

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

limit scroll area5

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

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

limit scroll area6

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar