I have a workbook with rows that need to remain hidden. There is quite a bit of VBA code and macros that run for different reasons. Everything works well except, anytime the autofilter is used to filter data, the hidden rows become visible. I have a macro (HideRows) written to hide the rows, but I would like it to run immediately after use of the autofilter.
I have waaaay too much data, and code running too often to run the macro on a selection change. The workbook functions fine, and I definitely don't want to slow up the calculations with this small fix to a big project... But I am almost sure there is a way.. simply put.. to run a macro, ONLY AFTER the use of the autofilter (and not on a selection change, change, or button click..)
Also, I have already inserted the existing macro (HideRows) to be called when running several other macros that collapse and expand the rows and columns. (However, this still doesn't solve the issue of the autofilter)
Any suggestions?
Bookmarks