One way is to modify a setting on the properties window for that worksheet.

Inside the VBE, show the project explorer (ctrl-r)
Select the worksheet you want to modify.
hit F4 to show the properties window
Scroll to the ScrollArea property and type the address you want to use.

You can also activate your sheet, then click on the developer's tab and click on
the design mode icon.

Then click on the properties icon and make that same change.

The bad news is that this setting isn't remembered if you close and reopen the
workbook (well, at least not in xl2003--not sure about xl2007).

But you can change the scroll area after you've opened the workbook without
using a macro.

Setting a scroll area in excel 2007 wrote:

Am creating a form to use for our calibration sessions and i dont want then
to scroll to other parts of the worksheet that is not necessary.

I will be using this for to tally and compare results of our audits are
calibrated.

can someone assist?

thanks!!!

--

Dave Peterson