Backing Up Excel Macros on a PC
Macros are associated with the file to which they are applied. When you back up an Excel workbook that uses a macro, you will automatically save that macro as part of the backup copy of the workbook. This also applies to macros associated with other files.
If you want to back up a macro independent of the Excel file with which it is associated, open the Visual Basic Editor while Excel is running by pressing Alt+F11. In the project explorer, right-click on the module, form or class that you wish to save, select export and save it to your laptop, external, network, or web-based storage.
To restore your macro go to the Macros dialog box, choose Restore. Next the macro set file you saved from your old laptop and then choose OK.