Sending Macros with a file

[Jason_2112]

I'm sure there's an easy answer to this, but I haven't been able to find it.

I have made a spreadsheet that uses some macros that I made. The macros are stored in "Personal.xls". When I send the file that uses the macros to someone else, they cannot use the macro features. I assume this is because the macro is stored on my computer and is not attached to the workbook itself. How can the other person trying to use the file get the macros that I created? Can I embed them with the file itself?

Thanks for the help

[Trebor76]

Hi there,

To put the macros onto the workbook your sending, do the following 6 steps:

1. Copy (Ctrl+C) the code you have created
2. Open the Visual Basic Editor (Alt+F11) on the workbook you want to send
3. Select Module from the Insert menu item
4. Paste (Ctrl+V) the code from step 1
5. Select Close and Return to Microsoft Excel from the File menu
6. Save the workbook

Kind regards,

Robert

HTH

[Jason_2112]

Thank you kindly. That was most helpful.