Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Word 2007 Custom Macros Network Sharing

Posted on 2010-09-09
3
Medium Priority
?
395 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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

2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

Question has a verified solution.

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

Provide an easy one stop to quickly get the relevant information on common asked question on Ransomware in Expert Exchange.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

670 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