Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education


Limit Scroll Area and Blocking Scroll Bar in Excel WorkSheet

How to limit scrolling on a worksheet Excel 2013

If you create your work on an Excel worksheet and want to allow the user can view or see only part of the worksheet ie. the information that are irrelevant for all the secret formula you used. On the same worksheet, there are additional elements and formulas related to the table that allow for viewing. Simply lock the 'scroll bar' sliders.

How to block Scroll Bar sliders in Excel

So, on Sheet1 we want to allow a user to view only a certain range of cells on Shee1 or in other words we want to prohibit a user to view the data or formula to the rest of Sheet1. To make disable a user may review the entire worksheet, do the following:

Click on the tab Sheet1 respective Workbook, right-click the shortcut menu and select 'View Code'.

How to block 'Scroll Bar' sliders in Excel

In the open VBE window, click Show 'Window Properties' if it is not active.
In the 'ScrollArea' enter the absolute address area range of cells that allow for review. In this example I have set permit views cell range $A$1:$X$270

Limiting and configuring the range of cells that are allowed to browse on the worksheet

Restrict access to the VBE in Excel 2013

Of course, if you want you can set the password in the VBE window that the user can not access the VBE and change ScrollArea.

Restrict access to the VBE to Excel

Save the Excel Workbook and then reopen it. Try to move the cursor (Scroll Bar) vertically or horizontally and you notice limit Row and Column to which you can view the worksheet.