How do I set a scroll area in excel 2007 without using VBA?

  • Thread starter Thread starter Setting a scroll area in excel 2007
  • Start date Start date
S

Setting a scroll area in excel 2007

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!!!
 
What I do is I hide all the rows and columns around the area I want people to
be able to scroll. To get all the way to the end of the columns/rows quickly,
select a column/row then press Ctrl+Shift+(any arrow key). To hide, select
columns/rows, right click "Hide"

If this helps, please click "Yes"
<><><><><><><><><><><>
 
Don't have xl07, but think you could play around with the sub below
(sub to be placed in the "ThisWorkbook" module):

Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "a1:d5"
End Sub

Adapt to suit. any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
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.
 
Back
Top