Digitally signing Excel/Word macros

I write macros for these from time to time. To get them to run I lower the security level, typically to medium, and respond accordingly to the application prompt.

I've Google'd and seen various ways of getting the macro 'signed' such that it'll be accepted. Any experience, good or bad, of ways or doing this?

Edited by cheshire_man (Sun 17-Jan-10 20:55:05)

what is the target audience for these macros? if for your own use or small audience - then just self certify them.

I used to have to sign a VBA macro project for work - it was a real pita because every year we had to re-sign it when certificate run out

Sorry I should have said they're purely for my own use.

How do I self-certify?

Presumably that'll work for Outlook as well?

Which version of Office are you using - for 2007 follow - Digitally sign a macro project

Mainly Office 2003 on desktop, I also have 2007 on netbook.

Edited by cheshire_man (Sun 17-Jan-10 21:12:59)

For 2003

Thank you kind sir.

In fact I've just tried the 2007 process on 2003 using Office Tools Digital Certificate for VBA projects - I've just found that is in fact the SelfCert.exe application..

It seems to be working fine in the one Outlook macro I have. I've been able to set the security level back up to High which is my preference.

I'll try it in the Word and Excel macros later.

Edited by cheshire_man (Sun 17-Jan-10 21:26:57)