Difference between revisions of "Backing Up Excel Macros on a PC"
m |
|||
| Line 1: | Line 1: | ||
| − | 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 | + | 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. | 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. | ||
Revision as of 14:46, 6 June 2017
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.