When a user opens an Excel file that has macros, and if there security is set
to medium or high, they get that dialog box that asks them whether or not to
enable macros.
With macro security set to Medium in Excle 2002, is there a way to disable
the request. I have tried checking both check boxes in Trusted Sources, to
no avail.

Thanks for any guidance.

The trusted sources approach will work, but only if the macros have a digital
signature (indicating a source whom you can trust). The cheap way to create
those signatures is for the macro author to find and run the selfcert.exe
file (part of the Office installation). Then open the macro in the VB
Editor, and from the menu bar choose Tools Digital Signature and select the
certificate; save and close.
Now the users will have the ability to indicate that the author is a trusted
source, and thereby bypass the dialog if security is set to medium. (Note:
I've found that certificates created under old versions aren't recognized by
newer versions, so the signer should use as recent a version of Office as the
users will).
HTH. --Bruce

"PA" wrote:

When a user opens an Excel file that has macros, and if there security is set
to medium or high, they get that dialog box that asks them whether or not to
enable macros.
With macro security set to Medium in Excle 2002, is there a way to disable
the request. I have tried checking both check boxes in Trusted Sources, to
no avail.

Thanks for any guidance.

Sounds promising, I will give it a try - THANK YOU

"bpeltzer" wrote:

The trusted sources approach will work, but only if the macros have a digital
signature (indicating a source whom you can trust). The cheap way to create
those signatures is for the macro author to find and run the selfcert.exe
file (part of the Office installation). Then open the macro in the VB
Editor, and from the menu bar choose Tools Digital Signature and select the
certificate; save and close.
Now the users will have the ability to indicate that the author is a trusted
source, and thereby bypass the dialog if security is set to medium. (Note:
I've found that certificates created under old versions aren't recognized by
newer versions, so the signer should use as recent a version of Office as the
users will).
HTH. --Bruce

"PA" wrote:

When a user opens an Excel file that has macros, and if there security is set
to medium or high, they get that dialog box that asks them whether or not to
enable macros.
With macro security set to Medium in Excle 2002, is there a way to disable
the request. I have tried checking both check boxes in Trusted Sources, to
no avail.

Thanks for any guidance.