You only need to set the security to Medium - allow the user to choose to run macros or not. If you want to put it to High and have it still run then you can look at my CodeBank thread on Creating Digital Signatures and signing VBA projects.