XL Disable/Enable Macro Dialog

[kiloez]

How can I disable the dialog window that opens when opening an XL workbook that contains VBA code? I prefer not to have the dialog display when the workbook opens.

 

[ETID]

create a digital certificate by running "selfcert.exe" (it should be in the office folders)

then apply it to you vba project in the vba editor,...it's one of the menu items.

when users open the workbook for the first time they will be prompted to always trust the cert. then "enable macros"

this is a one and done thing....if the worbook is on a network, each user/machine will have to accept the cert.

 

[Chattin]

You can set your security level to low (Tools>Macro>Security...) but this is really really not recommended unless you have a good AV program with up to date virus definitions. (Really not recommended!!!)