Unable to save macros in word 2007

[RobGMiller]

The word environment is setup to share macros using the normal.dotm located
in a shared drive.

This is configued in WordOptions.Advanced.FileLocations.UserTemplates

However, a recorded macro will not save in normal.dotm or in the current
document.

For instance, a simple standard process to illustrate the problem is to Open
a blank document. Use "Record Macro" from the Developer tab. The macro is
named in the popup and Document1 is selected from the "Store Macro in"
pulldown. Click Ok. Write a few letters. Use "Stop Recording". Save the
document and reopen it. The macro is NOT listed in the Macros editor popup
even when the current document is selected from "Macros In" Pulldown.

Thank you for your assistance.

 

[Graham Mayor]

You cannot share the Normal.dot file among multiple users in Word
http://support.microsoft.com/?kbid=811468 (this applies equally to Word
2007).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[RobGMiller]

Thanks for your reply Graham,

The sharing of macros seem to work using normal.dotm in a common network
folder for some folks. I guess word was never opened by two people at the
same time.

Would this sharing strategy cause the inability to save a macro in the
current document?

These macros need to be available to everyone using different templates and
need to be shared as soon as one is created without having to transfer it to
all possible templates.

Can you tell me what is the recommended way to accomplish this requirement?

 

[RobGMiller]

Thanks for the reply Graham,


I setup the templates and startup file locations to the local original
locations on two test computers. I also set the workgroup location to the
shared drive that was used for the Templates file location previously to
attempt to store macros in a common place.

The current list of macros are still available but now these two test
computers exhibit the same problem as the original computer who could not
save a macro at all.

 

[Graham Mayor]

Word is not a multi-use application. Only one person can have control of the
normal template which is an individual user file. Ensure there are no orphan
lock files - http://www.gmayor.com/what_to_do_when_word_crashes.htm

Then put your shared macros in a startup template (or in the document
template to which they refer). You can share document templates with the
Workgroup folder, but you will only be able to edit/save macros in them if
they are opened in Word and only one person can have them open at a time.

The individual normal templates should allow individual users to save their
own macros in the normal template.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[RobGMiller]

Thanks for your good advice on this issue Graham,

Do you think individual users could import macros from a common document
using VBA code. If the import is initiated from the person receiving the
macros, the document containing the macros would be opened read only. The
macros could be written to their own normal.dotm.

Since word is capable of handling macros in both the macro editor and the
organizer one would think that here is a macro handling object in word or in
office or in VBA.

Perhaps I should post this question to the Word Programming group.

 

[Doug Robbins - Word MVP]

See the article "Distributing macros to other users†at:

http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com