Private Sub in Add-In

**Vaw08** · 01-30-2013, 03:01 PM

I am attempting to create an Add-In in Excel. I want (on only one sheet) for this Add-In to run a private sub that runs a macro when the user double clicks on a certain range of cells.

I have this macro working fine in the file that I create the Add-In from. How do I get it to work in a different file once the Add-In has been installed?

I have installed the Add-In and gone to Tools>References in VBA, so that is not the issue. Any ideas on why the code won't run on double click??

**HaHoBe** · 01-30-2013, 03:05 PM

Hi, Vaw08,

simple answer: because an AddIn isn´t showing any worksheets to the user. To work around that you should have a look at Class programming where you Would catch the event in other worbooks and can work with that from the addin.

Ciao,
Holger

**Vaw08** · 01-31-2013, 12:15 PM

Thanks for your reply. This makes a lot of sense, and I now have my private sub working when the active workbook catches the double click event. Then it runs the macro from the add-in. I just have one issue. My macro unprotects the sheet, does something and reprotects. When testing the macro before making it into an add-in, it worked fine. Now, when I run the macro from within a different workbook as an add-in, it is making the changes I want, but then popping up and saying that the sheet is protected. Any ideas?

I tried Application.DisplayAlerts = False, but I got an error when I tried that.