• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

Word 2007 Custom Macros Network Sharing

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
0
RTEducators
Asked:
RTEducators
  • 2
1 Solution
 
MbrincatCommented:
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...?

0
 
RTEducatorsAuthor 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
0
 
MbrincatCommented:

have a look at the following

Auto Enrolment might be the better option, not 100% how this works but i think with the Certificates snap-in you can point to a network share and the PC will check for updates to the certificate and then automatically install and store them.

The below has more details.

http://technet.microsoft.com/en-us/library/cc757629(WS.10).aspx
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now