macro association

[justamailman]

I have tried the right forum but no answer so I am trying this one hopefully

I had a dot document with lots of macros on different menu bars and now
after transfering that file on an other computer (my laptop). I still have
the macros and the menu bars but the macros are not activated when I press
them . It seem like I would have to reinstall all the buttons association.
How come did I lose that in the transfer and where will it be ?

 

[Perry]

Grant trust and access to yr VB Project (on yr laptop)
Word menu: Tools | Macro | Security
dialog tab: Trusted Publishers

Krgrds,
Perry

 

[justamailman]

it was not checked in the add ins sorry thanks

Grant trust and access to yr VB Project (on yr laptop)
Word menu: Tools | Macro | Security
dialog tab: Trusted Publishers

Krgrds,
Perry

 

[Shauna Kelly]

Hi

I had a dot document

A dot, or a document? A .dot file is a template, which serves as the basis
for creating a new document when you do File > New and select the template,
or when you double-click the template from Windows Explorer.

There are two possibilities here.

The first (and my guess is the most likely) is that the code and the buttons
aren't all in the same file. Do File > Open to open the file and use Tools >
Customization to see if you can create a new button on a toolbar to invoke
one of the macros in the file. If that works, then there's some evidence
that the buttons have lost their connection to the macros. You haven't
re-named the macros or the modules that they live in have you? You can use
the Immediate window to re-set the OnAction property of a button. Eg:
CommandBars("mytoolbar").Controls(1).OnAction = "MyMacroName"

The second possibility is that the buttons are still attached to their
macros, but macro security is preventing the code from running.

Is the .dot file in the User Templates or the Workgroup Templates folder? If
so, at Tools > Options > Security, click the Macro Security button. On the
Trusted Publishers tab, tick the box "Trust all installed add-ins and
templates". That's code for "trust VBA code in all files in the User
Templates and Workgroup Templates folders.

Is the .dot file somewhere else? If so, at Tools > Options > Security, click
the Macro Security button. On the Security Level tab, choose Medium. You'll
now get a prompt every time you open a document attached to the template, or
create a new document from the template.


Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word