Getting around macro protection?

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

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.

HTH

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.

HTH
Binky