Changing autofilter fields

Y

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!
 
J

John

Yoav said:
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!
Click to expand...

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
 
Top