MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting around macro protection?

Posted by Kyle on December 20, 2001 8:57 AM

Is there any way to get that window that prompts to enable macros to not come up with macros still being there and without having to change the security level on Excel?

Posted by Joe Was on December 20, 2001 9:10 AM

Yes and no, only the user can change the setting, Tools-Macro-Security, take off High. To protect the system Microsoft has locked out any macro or VB way of getting around these settings.

Excel does no check for virus code, but if an application uses code or macros that application is flaged as could contain virus code. So it is a pseudo-check only. JSW

Posted by Mark O'Brien on December 20, 2001 9:16 AM

Yes and no.

The "no" answer first:

The reason it comes up is defined by the security level. It is the only real security measure to prevent malicious macros.

If you set the security:

LOW - then macros will be enabled automatically. As you are no doubt aware, by the phrasing of your question, this is a bad idea.

MEDIUM - it will always prompt you and give the option to ENABLE/DISABLE macros.

HIGH - Will always disable macros.

However, there is a "yes" answer. If the workbook comes from a "trusted source: valid signature" (see MS Excel help for more on this), then the workbook will be opened automatically with macros enabled.


Posted by Binky on January 02, 2002 12:02 PM

Yes. Create your own digital signature. It isn't hard to do. Look it up on the MS website. I founds lots as to what to do to make it so you only get the disable macros things once.