Word 2007 Custom Macros Network Sharing
Posted on 2010-09-09
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.