A
Allan Seidel
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
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