Limit Scroll Area Use Excel VBA

2 minutes to read
32150 7

The following VBA code can help you to limit the scroll area for a particular worksheet.

VBA code

Excel’s ScrollArea property allows you to set the scroll area for a particular worksheet. For instance, this statement sets the scroll area on Sheet1 so the user cannot activate any cells outside of A1:G10.

Sub LimitScrollArea()
    Sheets("Sheet1").ScrollArea = "A1:G10"
End Sub

If for some reason you need to clear the scroll area limits, you can remove the restriction with this statement:

ActiveSheet.ScrollArea = ""

How to Use This Macro

To use this macro, you can copy and paste it into a standard module:

  1. Activate the Visual Basic Editor by pressing ALT F11.
  2. Right-click the project/workbook name in the Project window.
  3. Choose Insert -> Module.
    Insert Module
  4. Type or paste the code in the newly created module.

Recommended content

  1. Save and Close All Workbooks at Once
  2. Insert Blank Rows Between Existing Rows In Excel VBA
  3. Create a Backup of a Workbook with Current Date
  4. Move or Copy Worksheets VBA
  5. How To List All Files In Folder And Sub-folders Use Excel VBA
  6. Create a New Workbook for Each Sheet

Most viewed

  1. Formatting a Range of Cells In Excel VBA
  2. How To Set Column Width In cm At Once
  3. How to Quickly Extract Pictures From An Excel File
  4. Select a Range In Excel VBA
  5. Find and Select the First Blank Cell in a Column VBA
  6. Print Worksheets VBA

Leave a comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>

7 comments
  1. TE
    TJ Ev

    This worked for me for desktop excel file but not for the online excel version.

More comments