On Sat, 5 Feb 2005 20:29:11 -0500, "Rick" wrote:

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.

Wow! I learned so much in this thread re this. Thanks. Interesting
to know about the charge, etc. I've opted to go a different route. I
put an extra sheet in my book.xlt labelled "H" (for "Help", though
know that won't be self-evident to everyone g), and I put a blurb re
the macros and macro security and how to fix macros that are disabled.
That seemed the best way to go that would cause least amount of
trouble. I have a message window _also_ pop up once they get the
macros to work by hitting a question mark button that says the same
thing. I figured I've covered all the bases.

It's the first company in all my years of working that has such high
security all across the board, but since it's related to border
services, one can see why security is high.

Thanks everyone! Appreciate the help, as always, you have no idea!

"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!