Word: Save your macros to a separate fileSeptember 9, 2010
Last week my husband’s computer had to be reinstalled with Windows, Microsoft Office and all the other applications. Life has been interesting since then, trying to get all the apps set up the way he had them before.
Several days later and he’s working away in a Word document. Happy, that is, until he wants to use the keyboard shortcut for a macro I set up for him ages ago that reformats a pasted table. And it doesn’t work.
I go looking, hoping that perhaps the keyboard shortcut is the only thing that got hosed, but the macro is gone too. Documents based on that template (and the template itself) don’t have any macros. Nada. Zilch. Zip. Nothing.
So I *assume* that I’d saved the macro to normal.dot (bad move!), and of course, when the system was reinstalled, the old normal.dot got wiped and reinstalled. Goodbye macros.
- Save your macros to a separate file and NOT to normal.dot — see this blog post of mine for full ‘how to’ details: https://cybertext.wordpress.com/2009/10/18/word-separate-out-macros-and-attach-them-to-all-documents/
- Store a copy of this file on an external hard drive, network drive, or cloud backup in case you have to reinstall your system.