This may not be the cause of your problem but if Tools, Options, View, Hide
All (for Objects) is selected the drop downs will not be visible.

--
Jim Rech
Excel MVP

Nope, that was one of the first things I checked. I have it set to "Show
All", and also tried it with "Show Placeholders." Same phenomenon. But I
expanded on your suggestion and checked to see if by some weird mechanism
using the AutoFilter method changed that setting, and it didn't.

I should have mentioned only drawback to my solution is you can't do certain
things, such as add/delete rows/columns, with the autofilter set on, even if
you have it showing all data, so may not be a workaround for everyone.

Thanks and regards,
Krisa


"Jim Rech" wrote in message
...
This may not be the cause of your problem but if Tools, Options, View,
Hide
All (for Objects) is selected the drop downs will not be visible.

--
Jim Rech
Excel MVP