I have a worksheet where I want to limit how far a user can scroll down.
For example, I want people to be able to scroll to row 27, but have the view
stop there and not allow them to be able to scroll down passed that line.
Even if I hide the rows under row 27, you can still keep scrolling down. I
want to stop that from happening.
Is there a way?

Thanks.

have a look in vba help index for scrollarea

--
Don Guillett
SalesAid Software

"gottahavit" wrote in message
...
I have a worksheet where I want to limit how far a user can scroll down.
For example, I want people to be able to scroll to row 27, but have the
view
stop there and not allow them to be able to scroll down passed that line.
Even if I hide the rows under row 27, you can still keep scrolling down. I
want to stop that from happening.
Is there a way?

Thanks.