Converting Macro to Add-In

[stephfr]

Hi

My macro is working perfectly well in the workbook where I created it and in other workbooks when I launch them from the main workbook. However, I tried to convert everything to an add-in and apart form the cell formatting at workbookOpen, nothing else works :

No Macros appear in the list of Macros
The sheetChange function within the active sheet doesn't work either.

Does anyone have any ideas ??

Thanks
Steph

 

[Andrew Poulsom]

If you have a Worksheet_Change procedure in an Add-In, it will fire when something in a worksheet in the Add-In changes (which is unlikely to happen), not when something changes on the active sheet in the active workbook. Or am I misunderstanding the situation?

 

[stephfr]

Hi Andrew

I changed the code to refer to activesheet so I would have expected it to work. Also, I have some macros that the user launches from the macro menu option (to convert data, export data, etc) but they don't appear either in the list of available macros in the add-in.

Does this make my problem more clear or not really?

Steph