If you decide to use the SelfCert.exe to sign your code, it will create a
personal certificate on your machine. You can then export it and provide it
to the users of your macros (if it's a small manageable group I suppose).
They, in turn, need to import it. Once they've done that, they will be able
to tell Office that you are a "trusted" publisher the first time they run
one of your macros. This way, they can keep their security level at High.

To export/import your personal certificate (after you've created it, of
course, using SelfCert), go into IE 6 -- Tools | Internet Options |
Content -- and look at the Personal tab.


"StargateFan" wrote in message
...
I ran across a new default, the security level at this new contract is
set for high. Everywhere I've been up till now, it's been medium, so
I'd never run into problem of macros not working until re-setting the
security level.

Since this is the case, and since I'm creating Word documents and
spreadsheets with macros to share with other colleagues, thought it
might be prodent to look into that "signed" business or whatever it's
called. I'm assuming that if I configure, or whatever, all these
macros in that way, that that will also perhaps stop the macro
confirmation box that keeps coming up whenever one opens up a document
with macros?? That would be ideal. These are necessary and safe
macros that I write strictly for the purposes of making people's lives
easier.

Any point in the right direction will be greatly appreciated. Thanks!