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.

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.

That would rather defeat the object of having security ... so, no.

Regards

Trevor


"Bret" wrote in message
...
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.

Bret:
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".

You and evey macro virus writer in the world. :) You can use a digital
signature and the user would only have to accept it once. See
http://support.microsoft.com/?kbid=288985


--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com