You do not alter the security settings as reasons mentioned. The way you do it is by signing your macro code with a Digital Certificate/Signature.

http://www.vbforums.com/showthread.php?t=402030

Another way is to write an AddIn and have the users install it.