ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bypass the "Macros may contain viruses . . ." message (https://www.excelbanter.com/excel-programming/343464-bypass-macros-may-contain-viruses-message.html)

al

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

Bernie Deitrick

Bypass the "Macros may contain viruses . . ." message
 
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" wrote in 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




Jim Thomlinson[_4_]

Bypass the "Macros may contain viruses . . ." message
 
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


Mike Q.

Bypass the "Macros may contain viruses . . ." message
 
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


al

Bypass the "Macros may contain viruses . . ." message
 
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


al

Bypass the "Macros may contain viruses . . ." message
 
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



All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com