Forum Discussion
VBA module in Word Normal Template not saved
I do not know what is happening to you. If you are in a corporate setting, your IT folks may be preventing changes to Normal.dotm from being saved, or overwriting any that you do save.
Workaround:
You could save in a different Global Template instead.
Take a look at: Install/Employ VBA Procedures (Macros) by Greg Maxey
Hello Charles,
Thank you so much for your quick response. On my side, I took the time to try your suggestions before answering, so please accept my apologies for the delay. My problem is not solved, but thanks to you I had deeper look in it. Strangely, it seems that if my code is less than about 10.000 lines, it fits well in Normal.dotm. Above, the problem comes back. I have no idea why. Thank you again for your help.
Kind regards,
Jean-Pierre
I keep almost all of the macros I regularly use in one or more separate global templates. Those are the macros that I have QAT buttons and keyboard shortcuts for. They are the ones that my customized ribbon uses. I have probably a thousand macros in my Normal.dot labeled as Private so they do not show up in macro lists. They are in more that fifty modules by subject/purpose. These are code snippets that I have picked up over the years and use when trying to write new code as examples. I keep backups religiously but do not really care if they all disappear (because I don't need them on a regular basis and because I have backups.
Here is my article about using a macro to save date-stamped copies of the Normal template in a separate folder.