Excel macros can make life easier. But imagine how nice it would be to take your macros with you when you go to use another computer. This isn't a difficult process, especially with a little forethought. There are multiple ways to take your macros with you no matter what computer you use.
Copying the Workbook
Video of the Day
Step 1
Determine where your macros are saved. You can save the macros you create in the workbook you are currently using or in your personal workbook. If you want to use your macros across different workbooks, you are most likely saving them to the personal.xls workbook.
Video of the Day
Step 2
Copy the workbook where the macros are saved to your chosen storage medium.
Step 3
Copy the workbook to the new computer and start using your macros.
Using the VBA Editor
Step 1
Copy the actual macros themselves from the Visual Basic editor.
Step 2
Go to Tools–Macro–Visual Basic Editor.
Step 3
Go to the Modules folder in the Project window in the left-hand corner of the screen.
Step 4
Open Module 1 and copy the code for the macros you wish to copy. Paste this into the notepad and copy to your chosen storage medium.
Step 5
Repeat Step 2 on another computer and go to Tools–Macros.
Step 6
Name your macro and paste the code from the notepad into the macro window. Press Create and close out of the Visual Basic Editor.