Very slow autofilter

I have a pretty big spreadsheet with over 10k rows.
I normally auto filter one of the columns in order to see the rows that I need to look at. That's normally not taking more than 3-4 seconds, but when I try to remove the filter it can take up to 20 seconds if not more. The thing I noticed is that if I click on the spreadsheet or hit the break key, the "undo filter" operation is done more or less instantly, and I don't see any "side effects" to this.
I was wondering if I could add this "break" within the macro that triggers the "undo filter" , so that I won't have to press Break everytime I run it.
I know it's dumb, but I can't think of better solutions and I've grown white hairs from waiting 30 seconds every time I use the filter.
The Macro is very basic,

Please Login or Register  to view this content.

Dont see the point to scroll one by one columns (this has been registered but do you really need it?

May be change all the content of your macro to:

Please Login or Register  to view this content.

(leaves filter on but clears all criteria)
or

Please Login or Register  to view this content.

(swithes filter off completly)

For sure you can delete again both scrollcolumn
the next thing - almost always what is recorded as:

Please Login or Register  to view this content.

can be done as

Please Login or Register  to view this content.

the alst thing - if a lot "happens on screen" it is wise idea to switch off screen updating during macro.

So - try changing your macro to:

Please Login or Register  to view this content.