Slow Advanced Filter

Hi all, this is my first post in tis forum... please be patient with me. I am only a beginner in VBA excel.

I have a spreadsheet at work with more than 33000 rows and 7 columns. I need to apply a filter to these data with multipe criteris (ranging from 1 to 500). I have used the Advanced Filter to do this task. When I record this Advanced Filter as a macro it works great as long as I trigger the program from the Developer ribbon. However, as soon as I place a Button on the spreadsheet and trigger the filter using this button the program slows right down. For example, a filter with 91 criteria takes 0.23 sec to execute when triggered from the ribbnon but 9.5 sec when triggered with the button. This time it takes for the program to run can increase to more than 180 sec the more criteria are applied. I have searched everywhere but can't find a solution to speed this program up with the Button intact. Without going into the detail, the button has to be part of the program. I would be thrilled if anyone can help me overcoming this problem...!

Humdinggaling, yes, I've tried the lot: screenupdating, manual calculation etc etc nothing works... and also remember when the program is intitated from the Developer ribbon it runs perfect... its only when intitated from the button that it slows down...

I might be terribly wrong, but perhaps its the button that's causing the issue. Maybe it is resulting in some refresh / calculation on its own.

Maybe you can try incorporating into the code to delete the button, run the code, then reinstate the button?

quekbc, thanks for your quick reply... yes, it is definetly the button... and i will try what you suggest! The problem is going to be that I have in this spreadsheet a total of three buttons doing all sorts of things and a list box that allows the user to select the criteria range...not sure how this will pan out...! But I will give this a go! Thanks

Are the buttons on the same sheet as the data you are trying to filter? If so, maybe you can try separating them unto separate sheets. That might help.

quekbc, as you suggested, I placed all the buttons and the listbox onto a seprate sheet that does not contain the data and the filter is back to its normal speed... I can't believe it... such a big relief...! Thank you so much for this tip... it doesn't make sense to me that it works, but it does! Fantastic!!!