Solved

Word 2007 Custom Macros Network Sharing

Posted on 2010-09-09
3
392 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
0
Comment
Question by:RTEducators
  • 2
3 Comments
 
LVL 2

Expert Comment

by:Mbrincat
ID: 33644304
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
 

Author Comment

by:RTEducators
ID: 33668189
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
 
LVL 2

Accepted Solution

by:
Mbrincat earned 250 total points
ID: 33669870

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you thought ransomware was bad, think again! Doxware has the potential to be even more damaging.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question