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:
Figure 1. The Properties window in 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.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2669) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Limiting Scroll Area.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Need an easy way to move through a spreadsheet using a mouse? Here are a couple of ideas.
Discover MoreWant to make fast work of moving from one worksheet to another? Here's how to do the task when you have a lot of ...
Discover MoreJumping to the last cell in a worksheet should be easy, but you may not always get the results that you expect. This tip ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-10-07 19:13:59
Robin Anson
When I set the scroll area, CTRL-END no longer takes me to the last used cell (even though it is in the scroll area).
CTRL+LEFT or CTRL+DOWN take me to the last cell in the row or column, but the page doesn't scroll to that.
Moving the selected cell with the arrow keys will move the worksheet on the screen, but only if the selected cell is visible. If it isn't visible the worksheet doesn't move as the selection does.
2017-03-21 06:37:17
Willy Vanhaelen
Simply by erasing the range so that ScrollArea is blank.
2017-03-20 10:15:03
So now, how do you reverse this?
"Bear Claw"
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Comments