The problem is I get the same behavior on a laptop and 3 different PCs with
different operating systems and monitors ranging from a clunky old
not-even-flat screen to a souped-up LCD flat panel. The only time the
dropdowns do not disappear is when I run it in Excel 97.

Alt+Down Arrow made the choices appear, but not the arrows.

I just created a new little spreadsheet and tested the Autofilter on/off,
and of course it worked just fine. So perhaps there is some other part of
the coding that is influencing this event (it's quite a lengthy macro), or
some corruption in the spreadsheet. I did go back to a very old backup that
had originally been used in Excel 97, and it did the same thing. I'll keep
testing to see if I can narrow this down some more. I am painfully familiar
with corruption in Access, but thankfully not so experienced with Excel
corruption.

Thanks for the ideas. I'll post again with results of my tests.

Regards,
Krisa



"Jim Rech" wrote in message
...
I know it is no comfort but I have a macro that toggles AutoFilter on and
off using the "no arguments" method you mentioned and have never seen this
problem in any version of Excel. Almost sounds like a video driver
problem
but that would likely affect all versions of Excel. If it were video
related scrolling the filter cell off-screen and back would make the drop
down re-appear.

I don't suppose selecting the cell with the on-but-invisible auto-filter
and
pressing Alt-DownArrow to open the drop down manually makes the drop down
arrow re-appear?

--
Jim Rech
Excel MVP