Add-In for Code Originally in Multiple Sheets

[Rack Khoun]

I'll lay out my problem in general terms first. If anyone has any ideas, I'll get more specific:

I have data in one sheet. I made charts for each category of data and in each Chart Sheet, I coded Chart Events that would change graphs based on my where I clicked using MouseUp and it worked beautifully.

However, the GOAL is my coworker wants me to use an Excel Add-In to Chart Events.

The PROBLEM is that I don't know how to use Excel Add-In to apply code to specific sheets.

I have ATTEMPTED:

For each chart sheet in my original codes, I converted them to a class module. The PROBLEM arises when I try to call the class module based on my selection of a specific sheet. The MouseUp code will not fire.

I read through CPearson's articles on Event procedures and John Peltier's article on Chart Events. It's just I have trouble applying these concepts to Add-Ins.

Thanks