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

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

--

Regards,
Nigel




"VanS" wrote in message
...
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.

"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

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

"David Messenger" wrote:

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