You can purchase a code signing certificate and use that to sign your apps before distribution.
Doing this means the app will automatically be trusted whichever location it is saved to.
It also won't need to be unblocked if the file is downloaded from the internet or from an email.

See VBA Project Signing - 1 (isladogs.co.uk)