Capture Worksheet_Change Event with Add-Ins

[rahulsarin]

Hello everyone,

I am new to this forum and would appreciate if someone could help me out.

I have a workbook with a worksheet_change event for a particular worksheet. It works fine. However, I don't want to distribute the workbook to someone, rather was hoping to create an add-in.

This is what I was hoping:
The add-in would create a button, which would load a template sheet from the add-in sheets to the activeworkbook. Then any changes to the sheets in the activeworkbook would trigger the worksheet_change event.

However, I want my addin code to execute whenever the worksheet_change event occurs.

Is this possible?

Thanks,

Rahul