Copy macro's to another file

[Mvdsandy]

Dear all,

For the first time I programmed a macro using VBA. It makes a new workbook with 2 worksheets of the current workbook. Inside those two sheets are buttons. If I send the file to my colleagues nobody can use the macro's because it will not copy the macro's into the new file.

Can someone help me with this macro?
I did not found anything about it on this forum or google. Can you guys please help me to make the program that copies the current macro's of that file into the new workbook? Thank you in advance.

 

[ChrisBM]

In order to save the macros in your file try saving the file as a .xlsm or a .xlsb file.

.xlsm - Excel Macro-Enabled Workbook
.xlsb - Excel Binary Workbook

That way the macros will be saved in your workbook.

Hope that helps, let me know if you have any issues.

Kind Regards,
Chris