office 2003 enable macros 1

[mrmovie]

I hope someone can help me with his.
I wrote a word addin, for want of a better word. It takes the form of a .dot file saved in the startup folder of office.
office 2000 doesnt complain but when used with office 2003 it says the macro is disabled. i can enable it manually by changing security to mediun, accepting the macro, then setting security back to high.
i need to do this automatically.
can this be done? or could someone advise on how the security certificate thing works?
i admit this is some what of a boot strap problem but there you go.

thanks
richard

 

[Nelviticus]

You can create your own digital certificate by using Selfcert.exe tool that was installed with office (do a file search for it). This will create a certificate that's stored on your machine.

Then, in the VB editor, you can go to the Tools menu and select Digital Signature. This will let you pick one of the certificates you have installed (you'll probably only have one).

After saving, you'll need to re-open it with security set to Medium. You'll have an option to 'always trust macros from this source'. If you enable this you can set your security back to High and you'll never be asked again about code signed with that certificate.

If you want to do the same on another machine you'll need to copy the certificate over to it (it's a .cer file) and do the last part on that machine too.

That's the long way. The short way is to go into your macro security settings and select the 'trusted sources' tab. If you tick the 'trust all installed add-ins and templates' option, then anything in your default template directories won't trigger a warning. I *think* that applies to the startup folder as well.

Hope one of the above helps!

N.

 

[mrmovie]

Thanks for the post N.
the first options are viable for use as it will be on 7800 machines. I think i will try for the last option with a registry hack,,,got to see if i can get it past our security team. they shouldnt have an issue as thats how 2000 works currently.
thanks again the post
respkt
mrmovie

 

[Nelviticus]

I think there's some way of making a certificate 'global' across a workgroup, unfortunately I'm not a network admin so I don't know. It'd be easier than hacking the registry on 8,000 machines! Have a word with your network admin or do a search on Microsoft's web site.

Cheers

N.