Forum Discussion
Word Macros issues
- Jun 18, 2022
George_Schwarz_newsg In the Visual Basic Editor, expand the Normal project and select each of the Modules in turn and then from the File Menu, click on Export and save the modules to a location on your computer.
Then, create a new document and save it as a Macro-Enabled Template (.dotm) in the Word Startup folder at (C:\Users\[your user name]\AppData\Roaming\Microsoft\Word\STARTUP
Then select that project in the Visual Basic Editor and using Import on the File menu, import the modules that you exported in the first step above. Then, click on the Save button in the Visual Basic Editor.
Then, close Word, and rename the normal.dotm template to OldNormal.dotm and restart Word. You macros will then be available from the file that you saved to the Startup folder as it will have been loaded as an Add-in.
If there were other customizations in the original Normal.dotm template that you want to retain, with Word shut down, delete the new Normal.dotm that was created and rename the original one by removing the Old from the file name, then restart Word and access the Visual Basic Editor and remove the modules from the Normal project.
With the macros in the Add-in, they will be quarantined from any misadventures suffered by the Normal.dotm template.
See also:
The best place to keep your important macros is likely in a separate Global Template rather than in the Normal.dotm template. This requires a bit more housekeeping but is worth the effort in my opinion.