Limit the Scrolling Area Range of Your Worksheet

This hack comes very useful when you don’t want your viewers to see all the data in your excel worksheet. You can easily define a scrollable range for each of your worksheet.
To do this:
Open up Excel’s Visual Basic Editor(Alt+F11). Or right click on the sheet name you want to set scroll area and select View Code.
Limit the Scrolling Area Range of Your Worksheet

Now go to Project Explorer(Ctrl+R) and select the sheet you want to set scroll area.
vba project explorer
Define the scroll range in the properties window(F4)
set scroll area in the properties window

Save it and see the result.

One Comment

Add a Comment

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

Notify me of followup comments via e-mail. You can also subscribe without commenting.