CODEWITHSUNDEEP
vbams-word
khargushoghli
khargushoghli

Reputation: 55

Lost Macros in Microsoft Word Global Template

All the macros I stored in the Normal.dotm global template of my Word 2007 document are gone except one minor one. This is the second time this has happened to me. (I know, I should've learned from the first time.)

Is there any way to recover them? Is there any way to prevent this from happening in the future?

Upvotes: 2

Views: 13267

Answers (3)

Galen Currah
Galen Currah

Reputation: 1

Once your macros are back, while Word is active:

  1. Press Alt+F11 to open your Macro manager.
  2. In the left-hand pane, see the items under Modules.
  3. This or these item(s) contain(s) macro(s).
  4. Right click on each item and choose "Export file..."
  5. Save the file to a safe place that you an remember. (You can write a macro to do all of this!)

When you lose your macros again, restore them:

  1. Press Alt+F11 to open your Macro manager.
  2. In the left-hand pane, right-click on "Modules".
  3. Chose "Import file..."
  4. Navigate to your saved macros file and open it.

Upvotes: 0

Catherine Combs
Catherine Combs

Reputation: 36

I had the same issue. For security purposes, our IT department has a program that each evening wipes out almost all of the macros saved to Normal.dotm on each individual's computer.

You will need to setup a Word Template that is Macro Enabled. Any macros you create need to be built directly in this template. You can do this by going into Word and selecting "File" and then "Open" instead of clicking on the template file on your server or desktop.

Upvotes: 2

Jose Ospina
Jose Ospina

Reputation: 2217

Go to \Users\YOURUSER\AppData\Roaming\Microsoft\Templates and see if there is a Normal.dotm.old or .bak files. Rename them and see if your lost data is there.

It worked for me too!

Upvotes: 5

Related Questions