You can set the ScrollArea property. E.g.,

Sub AAA()
Worksheets("Sheet1").ScrollArea = "A1:K100"
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Saadi" wrote in message
...
HI,
I wana try to restrict the users not to scroll more than 100
rows. like if a
person scroll the excel worksheet downward than it will not
scroll lower than
row number 100 and simililarly for column K.

Thanks,