Microsoft Word 365 (16.0) Word Options - Customize Ribbon - Macros: List not sorted

Wim_Kooy 

One more thing... Macro Naming and organization.

I have thousands of macros and cannot remember the names. I mark most of them as "Private" so they do not even show up on my macro list. When I need to, I go into the vba Editor and use Find there to search through a project.

If I know it is in a certain module, I can use the drop-down list of procedures in the module, which is sorted alphabetically.

Generally when saving a macro, I never use the name suggested by Word, just as I never use that name when saving a Building Block. I will start the name with what it is I am trying to work on. I.e., Watermark, SectionBreak, Paragraph, Font, Style, etc. Then add a bit more about what the Macro does. I do not start macro names with things like Add, Delete, Change, etc. Doing this makes it easier to find macros when they are organized alphabetically.

If you add comments to your macros, the vba editor's Find can search them as well for keywords.

Macros should not be stored in the NewMacros module. That is, for me, simply a scratch workspace and I delete the module from time to time. Organizing your macros by Beth Melton, Word MVP 

Macros that are really used in my day-to-day work are not stored in the Normal template at all but in various Global Templates. They are attached to ribbon buttons, QAT buttons, and keyboard shortcuts that are in the same template. QAT buttons and keyboard shortcuts can be created and saved in a template easily in the user interface, no need to go to XML. Most of the macros in my normal template are references, code that I have developed or stolen (with accreditation). I regularly back up my normal template because it seems that even on my own computer, bad things happen to it. This is even more so in corporate workspaces with IT departments that think they know better. Backup Normal.dotm template using a macro (That is one macro that I do store in and use from my Normal template.)