Scroll Bar Range Too Short; Need to Scroll Further Down the Workheet

[Tanner2004]

Hi Folks:

I can easily mouse-click inside the worksheet and scroll down to where ever I want using the wheel on the top of my mouse, but I can't do that with the right vertical scroll bar to view the full visible area using the right scroll bar. Is there any way to the expand the "range" of the scroll bar to at least cover the the visible scroll area of the worksheet.

I do have this code running to prevent users from wandering around too far from the Dash Board on the worksheet. Thanks for any help.

Please Login or Register  to view this content.

[Kaper]

Probably you cannot scroll, because there is nothing there to be seen.

Try adding "almost nothing", for instance space, just outside needed scroll area. Like:

Please Login or Register  to view this content.

This shall do the trick.

PS. Notice that even without it, you could scroll by pressing arrows at ends of scroll bar, but not by dragging it. Moreover - try to drag right scrollbar in empty (newly created) sheet - can you drag it more than to get row 2 at the top of screen?