When editing Microsoft Office VBA, how can I disable the popup “Compile error” messages?

Do the following in your VBA editor window (entitled “Microsoft Visual Basic for Applications”):

Click the menu “Tools” and then “Options“.

In the Options’ “Editor” tab, uncheck the “Auto Syntax Check” box. (See screenshot, below.)

This change does not make the editor stop compiling in the background and marking syntax errors in red (or whatever formatting is specified in the Options tab “Editor Format”).

MS Office programs share this common VBA editor, so if you change an option while editing VBA for Excel then you’ve changed it for Outlook, Word, etc.

MS VBA editor's Tools Options dialog box

Leave a Comment