We help IT Professionals succeed at work.

Word 2007 Custom Macros Network Sharing

412 Views
Last Modified: 2012-05-10
Hi Experts,

I have developed a custom macro for a document that is used frequently across a number of computers/ logins across a network. Word 2007 (with Security set to "disable all Macros except digitlly signed Macros) will accept the digital certificate once it is installed on that computer AND login, but once another user logs in, they have to find and correctly install the certificate for the word templates to work.

The other possibility is to have each user change the trust center settings to allow for a network location, but once again, every user has to complete this for every different computer they happen to be using. Very tedious and frustrating.

Is there a way to install the security certificate for ALL USERS on a PC that is shared, or to broadly change the trust center settings in Word 2007 across multiple computers shared over a network (e.g. to allow for a particular network drive to be 'trusted').

One of these solutions will work well for the PC's with Office 2007 installed, but for the others (with word 2003), installation of the security certificate would be the better approach as it doesn't have the trusted locations options.

Also, when installing the certificate (its a private key) is it better/ more appropiate to be installed in trusted publishers OR trusted root certification authorities?

If I have not supplied enough information for the question to be answered, please ask.

David Sampson
Comment
Watch Question

Commented:
I think if you put the certificates into the "Default User" under documents and settings. that give it to all users. although i think it only affects new users. alternatively try putting the certs into "all users" under documents and settings...?

Author

Commented:
I'm sorry, I am not sure how to put the certificates in either the default user or the all users, as the certificate has to be INSTALLED in order to be recognised by MS Word when the template opens.
When installing the certificate, its not a matter of users, rather it is a choice of "trusted publishers" or "trusted root certification authorities". See attached images.

Could you please advise?
david
Install.JPG
Locations-to-Install.JPG
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.