Bypass the "Macros may contain viruses . . ." message

Is there a way to bypass the standard warning for Excel files containing
macros.

We must leave the Macro security setting to Medium.

Thanks

Al,

Since you must stay at Medium level, you can:
1) Sign the project with an electronic signature, and add the signature to the "Trusted Sources"
list.
2) Open the file with another macro, from a file that is from a trusted source.

HTH,
Bernie
MS Excel MVP


"Al" <Al@discussions.microsoft.com> wrote in message
news:2EEA6D6E-146D-4819-A85C-03C06417F243@microsoft.com...
> Is there a way to bypass the standard warning for Excel files containing
> macros.
>
> We must leave the Macro security setting to Medium.
>
> Thanks

Nope... That is the whole point to the medium setting. To confirm with the
end user that it is ok to run the macros. Otherwise viruses would just
supress the warning. You can however look into digital signatures.
--
HTH...

Jim Thomlinson


"Al" wrote:

> Is there a way to bypass the standard warning for Excel files containing
> macros.
>
> We must leave the Macro security setting to Medium.
>
> Thanks

This was a big help to me.
http://pubs.logicalexpressions.com/P...cle.asp?ID=194
--
Mike Q.


"Al" wrote:

> Is there a way to bypass the standard warning for Excel files containing
> macros.
>
> We must leave the Macro security setting to Medium.
>
> Thanks

That looks very promising - thank-you !!

I will try following the steps and let you know how it goes.

Al

"Mike Q." wrote:

> This was a big help to me.
> http://pubs.logicalexpressions.com/P...cle.asp?ID=194
> --
> Mike Q.
>
>
> "Al" wrote:
>
> > Is there a way to bypass the standard warning for Excel files containing
> > macros.
> >
> > We must leave the Macro security setting to Medium.
> >
> > Thanks

Thanks - that worked perfectly

Would you also know of a solution working with IE?
The message is "Some files may harm . . ."
Is there a way to disable this for a specific file extension?

Thanks again
Al

"Mike Q." wrote:

> This was a big help to me.
> http://pubs.logicalexpressions.com/P...cle.asp?ID=194
> --
> Mike Q.
>
>
> "Al" wrote:
>
> > Is there a way to bypass the standard warning for Excel files containing
> > macros.
> >
> > We must leave the Macro security setting to Medium.
> >
> > Thanks