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?
--
Life isa journey not a destination

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?

If you prefer not to use VBA you can:
a) Select rows(!) 41-65536 Right(!) click one of the row numbers Hide.
b) Select Columns(!) J-AV Right(!) click one of the columns letters Hide.
Micky


"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?
--
Life isa journey not a destination