Scroll Limit
 

Hi...

On several sheets I don't want users to scroll beyond A1:Q61. Can this be
done?

Thanks

Gordon

Scroll Limit
 

Use ScrollArea property of worksheet

For example
Sheet1.ScrollArea="A1:Q61"

--
Haldun Alay

"Gordon" , haber iletisinde þunlarý
...
Hi...

On several sheets I don't want users to scroll beyond A1:Q61. Can this be
done?

Thanks

Gordon

Scroll Limit
 

Hi...

Apologies for being dim...where would this code live?

"Haldun Alay" wrote:

Use ScrollArea property of worksheet

For example
Sheet1.ScrollArea="A1:Q61"

--
Haldun Alay

"Gordon" , haber iletisinde þunlarý
...
Hi...

On several sheets I don't want users to scroll beyond A1:Q61. Can this be
done?

Thanks

Gordon

Scroll Limit
 

Probably the best bet would be in the workbook open event. Right click on the
XL icon next to File in the menu bar and select view code. Add something like
this...

Private Sub Workbook_Open()
Sheet1.ScrollArea = "A1:Q61"
End Sub

--
HTH...

Jim Thomlinson


"Gordon" wrote:

Hi...

Apologies for being dim...where would this code live?

"Haldun Alay" wrote:

Use ScrollArea property of worksheet

For example
Sheet1.ScrollArea="A1:Q61"

--
Haldun Alay

"Gordon" , haber iletisinde þunlarý
...
Hi...

On several sheets I don't want users to scroll beyond A1:Q61. Can this be
done?

Thanks

Gordon