If you are a heavy Microsoft Word or Excel macro user, you may have experienced this scenario: After a Microsoft Office update, all of your beloved macros are gone. Poof!
This has happened to me more than once and now I’ve learned to backup up my macros. This is actually a lot easier than you may think. What I do, is display the code for any of my macros, choose Select All from the menu, copy my macros to the clipboard and then paste the code into an external document. This can be and Evernote or OneNote note, a plain text file or even a Word file.
This technique also comes in handy if you use more than once computer and wish to quickly add in your favorite macros.
To Make a Backup of Your Macros:
- Click the Developer tab on the Ribbon.
- Click the Macros icon to display the Macros dialog.
- Click any of your macros and then click Edit. This will open the Visual Basic for Applications window and display all of the macros that you’ve created.
- Choose Edit > Select All from the menu or press the Ctrl + A keystroke combination.
- Choose Edit > Copy from the menu or press the Ctrl + C keystroke combination.
- Select File > Close and Return to Microsoft Word (or Excel) from the menu to close the Visual Basic for Applications window.
- Open the document or note into which you want to paste your macros.
- Choose Edit > Paste from the menu or press the Ctrl + V keystroke combination. The code for all of your macros will be inserted into the document. If you move to another computer or your macros mysteriously disappear from Word or Excel, you can paste in any or all of the macros from this document.
Share this post