Hi,

Could someone please help me with the following issue with the vertical scroll bar in Excel 2007?

I have a sheet with 500 rows and I limit the scroll area to a defined range through VBA (50 rows somewhere in the middle of the sheet). When I do this, the scrolling is correctly limited and the vertical scroll slider gets accordingly big (it takes almost all the vertical scroll bar, as I can see almost all these 50 rows on my screen). However, when I click the scroll slider (with the intention to slide it), it gets smaller (as if there were no scrolling limits) and I can virtually scroll it up and down from Row 1 to Row 500 (as indicated by the row number box appearing next to the slider) even though the screen doesn't move beyond the scroll area limits. Any idea how to fix this and have the slider size constant according to the scroll area size and not changing to a smaller size when clicked?
(I don't want/can not hide other rows).

Would appreciate your help.