Adding To Trusted Publishers Through Certificate Authority and Sharepoint

[Traveller From an Antique LAN]

Hi All:

This has elements of Office, Small Business Server and Sharepoint, so I'm
going to post to all three groups in the hope of finding an answer.

Our office runs Small Business Server 2003, and uses the included Sharepoint
Companyweb as its intranet. As part of that, we have put our Word 2003
templates onto companyweb.

Works slick....except that some of our templates have a VBA program, running
as a macro, that is blocked whenever Word is in High Security for macro's.
We could go to Medium security, but it's a pain for users to click on
enabling all the time, or we could go to low security (which I won't do for
obvious reasons).

My question is how, if at all, I can certify the macro or the Sharepoint
site so that individual users can leave settings on High security, and still
run this particular macro. Can it be done with our SBS box as a
Certification Authority, or am I going to have to go third party? Is third
party the only way to add someone to Trusted Publishers for Word?

Yes, I know that selfcert can solve this, but as I understand, it has to be
run on each individual workstation, and I'd rather not have to go through
all of it.

Perhaps Group Policy has a setting that will allow this?

Any and all suggested solutions would be welcome.

Craig Zawada

 

[Word Heretic]

G'day "Traveller From an Antique LAN" <[email protected]>,

You can use SelfCert to generate a cert that can be used to sign a
PUBLISH COPY of your development set. DO NOT SIGN YOUR DEV DOCS!

Now, assuming you STAY with this one certificate, which is SYSTEM
DEPENDANT (which is why many companies pay once for a proper key and
keep it on a lower-tech machine whose SOLE purpose in life is signing
stuff!) your users will only have to go through the new extended
directors cut version of the "Trust this bloody certificate" dialog
sequence once, and then all your stuff will be recognised.

However, I know it's heresy, but I canna help but notice that if you
deploy a quality virus checker across your SOE (my fav is Trend Micro)
and sensibly lock down IE settings, you can run with no macro security
with little risk.


Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Traveller From an Antique LAN reckoned: