Agreed. I was hoping there would be some way to sign the document, with a pgp key or cerificate of some description, and that our IT department would be able to set up a list of trusted developers which MSOffice would refer to when deciding whether to enable macros or not.

If that kind of solution were possible, most users could have macros disabled by default, except when a document with a good signature from a trusted source is opened.

From my experience so far, there isn't really a good solution for this.

Anyway, a bit off-topic.

Thanks both for your responses.