LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default no scrolling after an autofilter off following a custom view

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
picture disappears from view when scrolling. KimnJasonG Excel Discussion (Misc queries) 9 March 8th 07 03:51 AM
View Custom View with Sheet Protection John H[_2_] New Users to Excel 1 February 16th 07 05:54 PM
How to view a custom view when the worksheet is protected? JulesJam Excel Worksheet Functions 0 March 6th 06 02:15 PM
???is there a way to keep one row in view while scrolling down??? Jennie Excel Worksheet Functions 1 July 14th 05 09:32 PM
View row headers while scrolling Newsgirl Excel Discussion (Misc queries) 2 April 22nd 05 05:48 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"