Auto Filter

[Dave]

Hi

Is there anyway of removing the auto filter from certain columns. I only
want it on the first two and want to be able to remove or hide the button
from the rest?

Thanks

 

[James]

If you just highlight the first two columns and then check the auto filter
that should do the trick. It doesn't work with multiple selections ie columns
that are not side by side.

 

[Dave Peterson]

You can only apply the autofilter to a contiguous range. But you can use code
to remove the dropdown arrows from the columns where you don't want them.

See Debra Dalgleish's site:
http://www.contextures.com/xlautofilter03.html#Hide

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)