In order to use macros without being prompted every single time to accept them, you need to create a personal digital certificate using the aptly named Digital Certificate for VBA Projects utility.