How to limit scrollable area

[Guest]

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

 

[Nigel]

You could hide all rows and columns that the user should not scroll into?

 

[Guest]

If you have the following Text Variables Defined

SheetName ie "Sheet1"
MyScrollArea ie "A140"

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.

 

[Guest]

Thanks, David, sounds good. I'll give it a try.
God bless
Van