Backing Up Excel Macros on a PC

From WSU Technology Knowledge Base
Jump to: navigation, search

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 (e.g., Word, PowerPoint).

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.

Restoring Macros

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.

Related Articles