You have to do it with code:

Sub SetScrollArea()
Dim WS As Worksheet
Set WS = Worksheets("Sheet1")
WS.ScrollArea = "A1:K20"
End Sub

Change the parameters to meet your needs.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Sat, 19 Dec 2009 11:03:01 -0800, Sherees
wrote:

I want to lock scrolling, the report created should be viewed as one A4
sheet, users must not see an other area other than my report. How to do this?