how do I become a trusted publisher?

[Bob W]

How do I become a trusted publisher so I can distribute Word and Excel files
to people in my company without them being presented with the dreaded
'document contains macros' warning each time they open one of my
files/templates?

I've created all kinds of extremely helpful functionality in our team
templates and knowledge base resources, but it's all thwarted by this
warning - because people automatically decline to enable the macros.

 

[Graham Mayor]

See http://word.mvps.org/faqs/macrosvba/DistributeMacros.htm

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


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

 

[Bob W]

I don't see how the explanation gets past the problem of everyone getting
prompted with a 'this document contains macros' warning. Maybe I should be
asking how one acquires a security certificate...or whatever it's called...to
get around this problem.

 

[Ed from AZ]

You get the warning when the actual document being opened contains
macros. When the macros are in a template that is loaded as an add-
in, the warning does not appear.

Ed

 

[Graham Mayor]

As Ed implies, documents should not contain macros. Macros should be in
templates or add-ins. Installed templates and add-ins will not show the
security prompt if the users have their macro security set to trust
installed templates and add-ins, which is the simplest way to deal, with
this issue.

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


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

 

[Bob W]

Thank you - this is very helpful!

You get the warning when the actual document being opened contains
macros. When the macros are in a template that is loaded as an add-
in, the warning does not appear.

Ed

 

[Bob W]

Graham, thanks for explaining!

As Ed implies, documents should not contain macros. Macros should be in
templates or add-ins. Installed templates and add-ins will not show the
security prompt if the users have their macro security set to trust
installed templates and add-ins, which is the simplest way to deal, with
this issue.

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


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