Featured Product

Excel Daily News

How to dismiss macro warning.

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.

Maeibh1@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).

(6 responses) I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking n people per ye

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View my Privacy Policy and Terms of Use.