Macro not visible in macro list

Question

Hi All, 

I need some help please. I have a macro that copies specific columns from one workbook into a new workbook, and renames the headers.

I have saved the module into a XLAM file, but its not appearing in the macro list. The sub isn't private and the add-in has been enabled.

Thanks

Answer 1

I have saved the module into a XLAM file, but its not appearing in the macro list.

This is normal behavior, macros inside AddIns can executed from the UI only using a button.

So either you have to add a CustomUI.xml and all that

https://docs.microsoft.com/en-us/office/vba/library-reference/concepts/customize-the-office-fluent-ribbon-by-using-an-open-xml-formats-file

Sample file

https://www.dropbox.com/s/4xn12u5txvywk14/SimpleRibbon.xlsm?dl=1

or move the macro to your PERSONAL.XLSB file.

Andreas.

Answer 2

Thank you!