Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to trigger MsgBox for this event? | Excel Programming | |||
Event trigger in Excel? | Excel Programming | |||
Event Trigger | Excel Programming | |||
Trigger Event | Excel Programming |