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