Converting Macro to Add-In

stephfr

New Member
Joined
Aug 17, 2011
Messages
39
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,222,404
Messages
6,165,857
Members
451,988
Latest member
boo203

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top