Copy macro's to another file

Mvdsandy

New Member
Joined
Sep 26, 2014
Messages
3
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.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

ChrisBM

Board Regular
Joined
Sep 22, 2014
Messages
215
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,118
Messages
5,835,495
Members
430,360
Latest member
Ajonode

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
Top