If you have the following Text Variables Defined

SheetName ie "Sheet1"
MyScrollArea ie "A1:D40"

Use the Line Sheets(SheetName).ScrollArea = MyScrollArea

Should achieve what you are requesting.

If you use variables like the above, or a subroutine, you could make the
ScrollArea change as more data was entered or if otherwise required.

"VanS" wrote:

Hello,
I have an EXcel VBA app and want to limit what the user can see on each
worksheet. The user needs to able able to scroll a certain amount to view
only the work area, but any ideas how I can limit the viewable area to no
more than that. I assume to somehow limit the extent of scrolling, but the
work area can vary, at least vertically.
Thanks,
Van