Autofilter - couple of questions

[TroyMcClure72]

1. Can you remove options from the autofilter drop down list ie the (Blanks) / Top 10 etc.

2. Can you detect when an autofilter has been applied / removed?

 

[SkipVought]

TroyMcClure72,

Have you read VB Help on AutoFilter? That would answer question 2.

I do not understnad question 1, however. What do yo umean by, "remove options?"

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}