MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to dismiss macro warning.


Posted by Mae on October 24, 2001 9:47 PM

If our Excel file contain a macro and when we open it, a dialog box will appear asking us to select either'enable macro' or disable macro. Is there a setting in the Registry or INI which can make this dialog never appear.

Thanks for your help.

Mae
ibh1@time.net.my


Posted by Richard S on October 24, 2001 10:09 PM

In Excel, on the tools menu, Macro, Security, there is a Security Level tab. Click the lowest level and the warning will be disabled.

Posted by Dan on October 25, 2001 4:01 AM

Just remember that lowering the security makes you more vulnerable to a macro virus. That's the reason that the message is there, so that you can decide before the macro starts whether you want to enable it. But it's certainly your prerogative.

Posted by Jonathan on October 25, 2001 8:00 AM

If you're using it yourself, you can try selfcert. Start/Find "selfcert" (without the quotes). You may have to look on your installation CD. Fill it out with your name.
Now, back in your VBE:Tools/DigitalSignature and choose the one you just created.
I do this on my projects and when they're on my machine there's never any further Macro warning dialogue (not, that is, for the macros I have written myself).

HTH