Results 1 to 2 of 2
2005-08-04, 05:16 #1
- Join Date
- Feb 2003
- Thanked 0 Times in 0 Posts
Inconsistent scrollarea results (2000)
I'm getting inconsistent results with ActiveSheet.ScrollArea
I have a Forms combobox where a user selects one of several ranges on a wsh to view.
The event code first hides all rows, unhides the desired rows, adjust column width
then readjusts the scrollable area in order to keep the user within the desired "window"
Some selected ranges "freeze" the scolling for some reason. At first I thought that maybe
the range was only the size of the existing window, but this is only true sometimes.
See attached file. Any suggestions?
The Job Class and Job Title ranges are examples of where it does not work properly.
View the code to open the scroll area and see the event code.
2005-08-04, 06:35 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Inconsistent scrollarea results (2000)
The problem seems to be caused by the line
Range("AllRows").Rows.Hidden = True
It doesn't occur if you change it to
Range("A5:A65536").Rows.Hidden = True
(i.e. hide ALL rows below the frozen pane at the top)