Macros and Templates Word 2007

[tjbo]

I've been reading other post regarding this subject and I still can't seem to
get this down.

I'm trying to copy macros into templates after upgrading from 97 to 2007.
I do not have the original normal.dot. There are probably 25 macros and
about
15 templates. When I open a converted template, go to the developer tab,
and click
macros, I can see the list of 25 macros in the normal.dotm and current
template. When I go to the organizer to copy selected macros to the current
template all I see is NewMacros under the normal.dotm. How can I copy
individual macros into a template? These macros are made up of mostly
phrases to be inserted into a form field. In addition, I thought I would see
the add-in tab once I converted these templates. I only see it on a few and
it only has one unrelated macro populated. Thanks in advance for your help.

 

[Jay Freedman]

I've been reading other post regarding this subject and I still can't seem to
get this down.

I'm trying to copy macros into templates after upgrading from 97 to 2007.
I do not have the original normal.dot. There are probably 25 macros and
about
15 templates. When I open a converted template, go to the developer tab,
and click
macros, I can see the list of 25 macros in the normal.dotm and current
template. When I go to the organizer to copy selected macros to the current
template all I see is NewMacros under the normal.dotm. How can I copy
individual macros into a template? These macros are made up of mostly
phrases to be inserted into a form field. In addition, I thought I would see
the add-in tab once I converted these templates. I only see it on a few and
it only has one unrelated macro populated. Thanks in advance for your help.

When you open the VBA editor (Alt+F11) and look at the Project pane on the left,
you'll see that within the templates there are "modules" (something like
subfolders), and the macros are inside the modules.

The Organizer deals only with modules, not with the individual macros inside
them. NewMacros is the name of the module that's automatically created when you
record macros.

If you must copy individual macros from one template to another rather than an
entire module at once, you'll have to copy/paste the macro code itself. That is,
first open the destination template in Word; then select and copy one macro's
code from the NewMacros module in Normal.dotm, double-click the module in the
destination template, and paste.

The Add-Ins tab appears only when the converted template contains one or more
custom toolbars. Whether there are macros in the template has nothing to do with
it.

 

[Jay Freedman]

When you open the VBA editor (Alt+F11) and look at the Project pane on the left,
you'll see that within the templates there are "modules" (something like
subfolders), and the macros are inside the modules.

The Organizer deals only with modules, not with the individual macros inside
them. NewMacros is the name of the module that's automatically created when you
record macros.

If you must copy individual macros from one template to another rather than an
entire module at once, you'll have to copy/paste the macro code itself. That is,
first open the destination template in Word; then select and copy one macro's
code from the NewMacros module in Normal.dotm, double-click the module in the
destination template, and paste.

The Add-Ins tab appears only when the converted template contains one or more
custom toolbars. Whether there are macros in the template has nothing to do with
it.

I meant to add something else: Using macros simply to insert text is typical of
WordPerfect, but very un-Word-like. You might be better served by making
AutoCorrect or AutoText (Building Block) entries to insert text, and discarding
the macros altogether.

 

[tjbo]

Thanks much for the quick response Jay. If I were to keep just the module,
would you have any suggestion as far as applying the macros instead of adding
25 macros to the QAT? I do like your other suggestion though and I will try
to sell that to the the users. Thanks again,
Terry

 

[Jay Freedman]

Besides making buttons on the QAT (and 25 of them would make for trouble), you
can assign them keyboard shortcuts or use the Macros dialog. If you care to dig
into modifying the ribbon, you can make a custom group with a tool such as
RibbonCustomizer (http://pschmid.net/office2007/ribboncustomizer). Unfortunately
we've lost the ability to make custom toolbars as in Word 2003.

To make a shortcut, right-click the QAT and choose Customize, then click the
Keyboard Customize button at the bottom of the dialog. In the next dialog,
choose the Macros category, select a macro, and assign a shortcut key
combination to it.

To open the Macros dialog, use the Alt+F8 shortcut, or click the Macros button
on the View tab or the Developer tab. There, you can double-click a macro's name
to run it, or select it and click the Run button.