The way a corporate user would enable macros is to place the vba in a template which can be pre-loaded to the user machines so that the code is already trusted. Then your documents don't need to contain any code but they have that template set as the attached template.

Because the code is then coming from a trusted location, it can run without requiring 'enabling' or unblocking.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia