hiding autofilter arrows

**petca059** · 08-11-2010, 03:56 AM

I would like to know a way to hide the autofiltering arrows AFTER the autofiltering is done. To hide ALL the arrows on a sheet without taking away the autofilter.

Is there a way to do this without doing this when the filtering for each column is done? or without removing the criteria

**royUK** · 08-11-2010, 03:59 AM

See this, you can adapt the code

**petca059** · 08-11-2010, 04:31 AM

I was just looking at that, but that was not what i had in mind i think?

When using this im having trouble keeping the "filtering mode".
Each time i use the "autofilter" i have to keep the criteria?
I want to hide the arrows when the autofiltering is done.