First, not worksheets, but documents.
Keep backups of your Normal.dotm file. That way, if something goes wrong, you can backup to where it was working.

• Backup Normal.dotm template using a macro

See:

• Instructions for Installing Macros from Forums or Websites by Graham Mayor, MVP
• Install/Employ VBA Procedures (Macros) by Greg Maxey
• Word Macros and Visual Basic for Applications (VBA) FAQ
• How to Modify a Recorded Macro by Jay Freedman

My Addins Download has a number of files that you can download and look at.

• Add-Ins (many, but not all, have macros)

Eventually, you will want to store your macros in one or more different .dotm templates to use as one or more Add-Ins rather than keep them in your Normal.dotm template.


Here is my page about the Developer Tab and the controls on that tab.


Also, there is a separate forum here available for vba questions.
https://www.msofficeforums.com/word-vba/