Autofilter macro won't run if another has already been run

**lukasj13** · 09-24-2010, 07:35 PM

Hi,

I am creating a project pipeline sheet, and have created 6 buttons with macro's attached to them. They all work, but I have a problem when it comes to my autofiltering ones. There may be an easy fix, but I don't know what it is.

Problem: Autofilter button #2 won't work properly when Autofilter #1 has been pushed, unless the autofilter function is turned off before pressing button #2.

Solution?: A line of code that says if autofilters = on, then turn autofilters off. I should then be able to run the rest of the code....hopefully.

I have attached a sample of the sheet that I am working on.
Thanks for your help in advance.........Lukas

**shg** · 09-24-2010, 07:44 PM

Please Login or Register  to view this content.

**davesexcel** · 09-24-2010, 07:44 PM

Check this out
http://www.contextures.com/xlautofilter03.html#Off

**lukasj13** · 09-24-2010, 08:01 PM

Originally Posted by davesexcel

Check this out
http://www.contextures.com/xlautofilter03.html#Off

I was actually just looking at that, for some reason couldn't get it to work. I used what Shg gave me a it works great. Thank you both for your help. I knew it was something simple, I have just been starring at this sheet for hours and my brain seems to be malfunctioning, and I seem to be over thinking things. Again thanks for you help, have a great weekend!!!!!!!!!!!!!!!!!!!!