Altering the "Workbook_SheetChange" event dynamically from an add-in

[pczegle]

I wrote a macro that dynmically filters an Excel table as the user makes entries into it. The rest of the table is filtered based on the contents of the row into which the user is making changes / additions. When all columns in the row have been entered, only duplicates of that row will survive the dynamic filter. The macro resides in an add-in. I also defined a toggle for this dynamic filtering capability that users can switch on and off from the menu bar.

Question:
In order for this to work, the "Workbook_SheetChange" event of the workbook being changed must pass control to the macro in the add-in. In case the user opens a workbook that does NOT have the "Workbook_SheetChange" event pass control to the macro in the add-in, I'd like the "Workbook_SheetChange" event to be altered on the fly when the user turns the dynamic filter toggle on. Is there a way to do this?

Thanks.