If what you're doing is ONLY on a Local Area Network (not downloadable or
otherwise available outside your network) then it MAY be possible to create a
certification.
Look up documentation on a program called SelfCert (I think).
I've not used it myself, but from what I've read from others, it would be a way
of certifying your macros  within your organization. Which would then allow the
macros to be run  without the prompt.

Keep in mind that I have no personal experience with this. I happened to be
looking a it to solve another problem, which it did not do, but I recognized the
potential.