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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
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
Click to expand...
 
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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 

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

Similar Threads

If I create a Word Macro, why aren't I a 'trusted publisher' ? 2
How To Find A Macro -- Word 2007 4
Allow Trusted Locations on my network - Group Policy (GP) 2
How do I become trusted 3
Macro security! 1
How do I prevent the macros message in Word 2002 startup? 1
How to eliminate WinXP MS Word Macro multiple dialog box annoyances? 1
How do i stop design mode when opening a document 1

Top