Limiting Scroll Area

When putting together a worksheet for others to use, you may want to limit the cells that the user can access. One esoteric way to add limits is to use the following steps:

1. Right-click the sheet tab for the sheet on which you want to place a limit.
2. In the resulting Context menu, choose View Code. The VBA editor appears, displaying the code window for the worksheet whose tab you right-clicked.
3. If the Properties window is not visible, press F4.
4. In the Properties Window, place the insertion point in the box to the right of the Scroll Area property. (Click here to see a related figure.)
5. Enter the range in which you want navigation possible. For instance, if you want the user to only be able to access the cells in the range A3:D15, then enter that range.
6. Close the VBA Editor.

That's it; you can no longer move to or select cells outside the range you specified in step 5. The range you enter must be a contiguous range; you cannot enter a non-contiguous group of cell addresses.