Using autofilter to trigger an event
 

I have a macro that I want to execute every time an Autofilter is updated in
an Excel workbook, but updating an Autofilter does not trigger the workbook
SheetChange event or the worksheet Change event. Can anyone point me in a
direction I need to look in?


Thanks€¦

--
Kevin Backmann

Using autofilter to trigger an event
 

Kevin,

You could use a cell with a SUBTOTAL formula call to the filtered range and the worksheet's
calculate event will then fire when the autofilter is changed.

HTH,
Bernie
MS Excel MVP


"Kevin B" wrote in message
...
I have a macro that I want to execute every time an Autofilter is updated in
an Excel workbook, but updating an Autofilter does not trigger the workbook
SheetChange event or the worksheet Change event. Can anyone point me in a
direction I need to look in?


Thanks.

--
Kevin Backmann

Using autofilter to trigger an event
 

Many thanks Bernie for such a straightforward solution, I was making it a
bit more complicated than it turned out to be.

Thanks, you've saved me a lotta' time...
--
Kevin Backmann


"Bernie Deitrick" wrote:

Kevin,

You could use a cell with a SUBTOTAL formula call to the filtered range and the worksheet's
calculate event will then fire when the autofilter is changed.

HTH,
Bernie
MS Excel MVP


"Kevin B" wrote in message
...
I have a macro that I want to execute every time an Autofilter is updated in
an Excel workbook, but updating an Autofilter does not trigger the workbook
SheetChange event or the worksheet Change event. Can anyone point me in a
direction I need to look in?


Thanks.

--
Kevin Backmann