Solved

Word 2007 Custom Macros Network Sharing

Posted on 2010-09-09
3
389 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
Comment Utility
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
Comment Utility
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
Comment Utility

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
As a financial services provider, your business is impacted by two of the strictest federal regulations on record: the Sarbanes-Oxley Act and the Gramm-Leach-Bliley Act. Correctly implementing faxing into your organization to provide secure, real-ti…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now