How do you get the script to run without asking the user to enable macro

The .OTM file needs to be signed w/ a digital certificate, set macro
security needs to be set to low, or create a COM Add-In.

See http://support.microsoft.com/support/kb/articles/q217/2/21.asp for more
information.

You can also get this article by sending an E-mail with a subject of

This link should automate that process for you: