+ Reply to Thread
Results 1 to 1 of 1

Run macro after use of autofilter (ONLY)

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Phila, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Run macro after use of autofilter (ONLY)

    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?
    Last edited by prsupport; 10-02-2012 at 11:26 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1