Copy macro into multiple users normal.dot

[lhall33950]

We use Word 2003. I have built a custom toolbar that includes macros in some
of the toolbar buttons. How can I copy either one particular button
containing a macro or if necessary the entire custom toolbar into the
normal.dot of the other users on my network?

 

[Ed]

We use Word 2003. I have built a custom toolbar that includes macros in some
of the toolbar buttons. How can I copy either one particular button
containing a macro or if necessary the entire custom toolbar into the
normal.dot of the other users on my network?

Don't mess with the Normal.dot. See
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

Ed

 

[lhall33950]

I read the info you referred me to. It tells me to copy the macro code into
a template. How do I do that?

 

[Cindy M.]

Hi =?Utf-8?B?bGhhbGwzMzk1MA==?=,

I read the info you referred me to. It tells me to copy the macro code into
a template. How do I do that?

In Tools/Templates and Add-ins click the Organiser button. There's a tab for
"Macro Project items". Make sure the source and target files are displayed.
Select the entries to be copied then click the Copy button.

Word 97 and later can copy only complete modules, not single macros.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Ed]

I read the info you referred me to. It tells me to copy the macro code into
a template. How do I do that?







- Show quoted text -

If you want to get into Word macros to any depth, you really need to
get familiar with the Word FAQ site. That's the best thing I ever
did! That, and learn to do Advanced searches with Google Groups.

http://word.mvps.org/FAQs/MacrosVBA/index.htm
http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm
http://word.mvps.org/FAQs/MacrosVBA/OrganizeMacros.htm

You'll need to have open both the template where your macro is
currently stored (probably Normal.dot) and the template you want to
put it into. Do not double-click these templates to open them - the
default behavior on double-clicking a template is to ceate a new
document based on that template. Instead, find the folder that
contains the template, right-click the icon and select Open.

THen hold ALT and key F11. You are now in the Visual Basic Editor.
You should see an Explorer window on the left that shows all your
projects. On the menu, Tools >> Macros. Highlight your macro in the
list, then click Edit. Select all the macro code from Sub at the top
to End Sub at the bottom and Copy.

Find your new template on the left and click to highlight. Menu -
Insert >> Module. Paste all your code into the new blank module.
Save and close.

Ed