• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cannot scroll after Autofilter on only certain items

C

Cruiser

Member
Protected sheet, scroll area set, autofilter works perfectly. However, when selecting some criteria from the autofilter list, the page will not scroll.
1. Scroll area is set well below the bottom row of the table on which the autofilter is applied.
2. The non problem and problem criteria area all being selected from the Autofilter list in the same column.
3. I have freeze panes on, but I can't see that as a problem because panes are frozen ABOVE the table being filtered, and, again, the page scrolls just fine after selecting most items in the autofilter.
4. There are no worksheet change events except a Workbook_SheetBeforeRightClick event which hides some right click selections from the user, but I can't see that effecting scrolling.
I can select 90% of the items in the autofilter list for this column and scrolling is fine. However, after autofiltering SOME criteria, the page will not scroll. Thoughts?
 
I should mention that I am designing an all-versions workbook, and so I am currently working in excel 2003. So, a strange twist has come to light... As long as one of the other columns is sorted "decending" BEFORE selecting one of the "problem items" in filter list of the "problem" column, the page scrolls properly. From there, I can go back to another column and "sort ascending" and the page still scrolls properly. However, if another column is not sorted "descending" first, selecting certain items in the "problem" column locks scrolling. Anybody have any ideas?
 
I SOLVED this. It must not be a common problem, since there were no replies to my post. However, if you run across this problem and manage to find my thread, I'll tell you what worked for me. I had to set my scroll area to 300 rows below the actual used area! Yep. 100 rows didn't help. 200 rows, nothing. 300 rows, magic. Why? I have no idea. I guess it's just a quirk of 2003.
 
You must log in or register to reply here.
Back
Top