Changing autofilter fields

[Yoav]

Hi,
Can I change the autofilter properties by code?
For example, defining that Text1="aaa".
I do not want to use the built in Filter, only autofilter.
thanks!

 

[John]

Hi,
Can I change the autofilter properties by code?
For example, defining that Text1="aaa".
I do not want to use the built in Filter, only autofilter.
thanks!

Yoav,
If you mean that you want to change what the custom window shows for
customizing autofilters, then yes, all you need to do is to rename the
field using the CustomFieldRename Method.

However if you are using VBA why mess with autofilters at all? Why not
use the FilterEdit Method. It has a lot more flexibility.

John
Project MVP