How to limit scrollable area

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top