CaptRon
07-05-2007, 07:09 AM
There is probably a simple solution to this that I am overlooking, but its driving me NUTS! :banghead:
On the several worksheets in a workbook, the length of the scroll bar varies depending on the area of the sheet that is utilized. If the scroll area is large the scroll bar length is diminished. Fine.
But sometimes something is clearly out of whack here. My scroll area should not extend to row 9000 (row 759 max). I end up with a scroll bar on this sheet nearly invisible but two inches long on the other sheets.
Is there a way to get these scroll bars more uniformly sized? How do I tell Excel there's nothing down there? I've tried just deleting the rows. Takes forever and hasn't worked.
Thanks.
Ron :thinking:
On the several worksheets in a workbook, the length of the scroll bar varies depending on the area of the sheet that is utilized. If the scroll area is large the scroll bar length is diminished. Fine.
But sometimes something is clearly out of whack here. My scroll area should not extend to row 9000 (row 759 max). I end up with a scroll bar on this sheet nearly invisible but two inches long on the other sheets.
Is there a way to get these scroll bars more uniformly sized? How do I tell Excel there's nothing down there? I've tried just deleting the rows. Takes forever and hasn't worked.
Thanks.
Ron :thinking: