Forum Discussion
Macros in word have died
WR-C_359Let me start by saying that I am not on a Mac.
First you should be using and applying styles for formatting to the extent possible.
What is it you mean when you say "macros have died?"
Let's talk about macros in general.
By default, all recorded macros are stored in your Normal.dotm template in a vba module named NewMacros. That is not necessarily the best place to store them, though. See Beth Melton’s article on organizing your macros linked below.
If you want to be having documents formatted a certain way you should consider having templates that are formatted the way you want and using those to create new documents based on those templates. That is the best way to insure documents set up the same way every time.
If you are talking about certain text or paragraph formatting setups, you should be using Styles, not macros. Macros for this are using a shotgun where you should be using a scalpel. You can be doing damage to your documents. In any case, they will be harder to maintain and edit.
What follows is general advice that may not apply. I've found that people writing here with lots of macros, though, are often using macros when they should be using something else:
If you are using macros for text snippets, you are using the wrong Word feature. This does not apply to your reformatting macros.
You should be using AutoText, which can also have keyboard shortcuts.
Both AutoText and AutoCorrect can be used for text snippets. These are different features and are both valuable. I use both virtually every time I use Word.
AutoText can have keyboard shortcuts and can AutoComplete; AutoCorrect acts on trigger words as you type. Here are some more resources:
- Exploiting AutoCorrect by Suzanne Barnhill, MVP
- Using Autotext to deal with repetitive text - Legal Office Guru
- Create reusable text snippets
- Word for Wordperfect Users
- AutoFormat and AutoCorrect (Tame AutoFormat) by Suzanne Barnhill, MVP
- Automated Boilerplate Using Microsoft Word on my website
For anyone who uses Word more than occasionally, I recommend the series of short tutorials prepared by Shauna Kelly a while back. Basic Concepts of Microsoft Word - from Shauna Kelly The styles article linked above is one of these.
If you want to track down more on your macros, I recommend looking at some of the threads you will find on the Microsoft Answers forum. Here are three searches there:
- https://answers.microsoft.com/en-us/search/search?SearchTerm=macros%20stopped%20working&tab=&status=...
- https://answers.microsoft.com/en-us/search/search?SearchTerm=can%27t%20record%20macro&tab=&status=al...
- https://answers.microsoft.com/en-us/search/search?SearchTerm=macros%20broken&tab=&status=all&advFil=...
Other resources:
Thank you for taking the time to respond. I have been over all the links you provided, and unless I missed it, there is no way except with macros to do quick edits like removing tabs, extra returns or double spaces without a macro find and replace.
If I did miss it, please provide me with the information because, at this point, I'm ready to change programs.
Again, thank you
I am a volunteer fellow-user of Word and have no vested interest in your staying with Word.
The use you describe is a good one for macros.
Did you look at the search links I provided and the threads they revealed?
Did you look at the suggestions for other places to store your macros that can be less vulnerable?
Did you consider making regular backups of your Normal template so that if something weird happened to your macros you had them backed up?
The following may help you in cleaning up the work done by others:
Word is, in my opinion, the most powerful Word Processing program available commercially. I have used a number of others over the years.
It is far from perfect. Thing happen to the normal template. Not often or frequently, but they do.
Recorded macros are imperfect tools but to a limited extent they should do what you have been using them to do. The Editorium has a number of perhaps more sophisticated ones that you could probably use. The ones on the linked page are free.
The most powerful Word program is the one written for Windows. The Mac program is second to that and some macros that work in the Windows version need to be rewritten to use on the Mac. They are slightly different programs.
You may be happier with another commercial program or with a free alternative like LibreOffice.
Note: Here is a temporary link to a zip folder with the Editorium Author templates. The ones on their site are in .dot and .doc format. In Ribbon versions, the controls all appear under the Add-Ins tab. I have added .docm and .dotm versions. All contain macros. I've tested some but not all of the macros in Word 2021 / 365 desktop. The updated files have had not changes by me other than putting them in the new format.
Many systems have file blocks for .doc and .dot files, especially containing macros. These blocks can be changed in Word preferences/settings but that adds one more impediment to use. To use these, they should be in a "Trusted Location" or you should allow the macros to run if queried by Word about it.
Until you are used to using them, I recommend using them on copies to see what they do.
Also on the Editorium page I first gave you is a link to download "Advanced Find and Replace in Microsoft Word" for free. This is a free early version of the book "The Wildcard Cookbook" by Jack Lyon.
See also: https://www.techtoolsforwriters.com/self-editing-toolkit/