Copying Macros from normal.dot to specific files for others to use

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a_ryan1972 - 02 Feb 2006 17:09 GMT

I have a bunch of macros stored in normal.dot. As of now, I am the only
person using these macros, but in a few weeks, that's going to change. Is
there a way to copy the macros into the specific documents so that whoever
opens the document can use the macro? I don't want to install my normal.dot
file on any other computers because other people might have specific settings
in their normal.dot that are different from mine.

Is this possible?

Reply to this Message

Jay Freedman - 02 Feb 2006 17:36 GMT

> I have a bunch of macros stored in normal.dot. As of now, I am the
> only person using these macros, but in a few weeks, that's going to
[quoted text clipped - 5 lines]
>
> Is this possible?

You're quite right not to replace other users' normal.dot files.

Move the macros to a separate template that you store in the Startup folder,
which makes it a global add-in (that is, the macros are available in all
documents, just as they are when they're in normal.dot). You can then send
that template to other users to store in their Startup folder. See
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm for details and a
suggestion about how to update the template when necessary.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Reply to this Message

Charles Kenyon - 03 Feb 2006 06:40 GMT

See http://addbalance.com/word/movetotemplate.htm for step-by-step
instructions on moving / sharing / copying / backing-up customizations
including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
etc.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

>I have a bunch of macros stored in normal.dot. As of now, I am the only
> person using these macros, but in a few weeks, that's going to change. Is
[quoted text clipped - 6 lines]
>
> Is this possible?

Reply to this Message

Rate this thread: