enable diable macros

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" <[email protected]> wrote in message
news:[email protected]...
>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


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