XLAM Module not showing in macro list

[littlebird1]

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.

Screenshots attached.

Cheers

 

[maabadi]

You should save your file as personal Macro workbook or copy and Paste your file to this Address:
Change yourusername to your pc username.

C:\Users\YourUsername\AppData\Roaming\Microsoft\AddIns

 

[Fluff]

Macros in add-ins do not show in the macro dialog box

 

[littlebird1]

Thank you both.

 

[Fluff]

Glad we could help & thanks for the feedback.