Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have a workbook consisting of a large table with special VBA
automation designed to view the table in a number of different ways as the users might wish. Much of the automation relies on autofilters. Many quirks and bug related to the autofilter has revealed themselves over the years. Now we think we have run into another and we are looking for insights into this. Perhaps it is nothing. A user has saved a custom view. Scrolling stops when using this view followed by turning the autofilter off. When this happens the cell address readout shows chaanges to the active cell location but there is no scrolling going on and the cell contents box remains blank. The right hand elevator bar also turns into a thin line as if the scroll range is very large. (Whoever thought up that user interface concept should be sent to hard labor.) Normal scrolling can be restored either by unfreezing panes (the table is normally frozen just below the table header) or by selecting another restoring custom view we have recently setup to handle this condition. The workbook close and open vba macros invoke the restoring custom view as a quick and dirty patch to handle the situation. We are running Excel 2000. There are a number of ways we could deal with this. What we are really looking for is an understanding of what is happening Is this a known bug or are we missing something? We have dug into Microsoft's Excel knowledge base for a while with no results on this particular issue. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
picture disappears from view when scrolling. | Excel Discussion (Misc queries) | |||
View Custom View with Sheet Protection | New Users to Excel | |||
How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
???is there a way to keep one row in view while scrolling down??? | Excel Worksheet Functions | |||
View row headers while scrolling | Excel Discussion (Misc queries) |