Stop Auto-Scroll When Applying a Filter

[[email protected]]

Morning, Gurus. I work on several worksheets that have many columns, and I often need to apply a filter. When you apply a filter in Excel the worksheet automatically scrolls all the way to the far right side of the table, so you must manually scroll back to the column where you applied the filter. Is there a way to stop it? Maybe a workbook event that prevents scrolling only when you apply the auto filter? Maybe an event that lets it scroll but then return to the same column? Any ideas?

Thanks in advance.

[[email protected]]

Am I the only person the auto scroll irritates?

[[email protected]]

This must either be impossible, or perhaps the code would do more hard than good, because you guys have never let me down. Appreciate you looking.

Have a good one.