I can give you three suggestions:
1. Set security level in all workstations (tools/macros/security) to low,
which is a security risk
2. sign your macros with a certificate, trusted by all workstations in your
company
3. create a Self signed certificate (with the selfcert.exe tool provided by
MS) and then sign the macros. You will have to "trust" this suignature on all
workstations

"Bret" wrote:

I regularly rollout VBA Excel programs within our company (100 - 1000 users)
Is there a way to turn off displaying the dialog box that ask user to
'disable or enable or macros. I want it always to default to "enable
macros".

thank you.