how do I become a trusted publisher?

B

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.
 
B

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.
 
E

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
 
G

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
B

Bob W

Thank you - this is very helpful!

Ed from AZ said:
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
 
B

Bob W

Graham, thanks for explaining!

Graham Mayor said:
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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top