Disabling “Compile Error” popup on PC
To disable, click Tools, then select Options. On the Editor tab of the Options dialog box, uncheck the Auto Syntax Check option, then click OK.
Disabling “Compile Error” popup on a Mac
To disable, click Excel, then select Preferences. On the Editor tab, uncheck Auto Syntax Check option, then click OK.
But Why?
In theory, it sounds like a good idea to have a popup warning to notify you that the code you have written has errors. However, in practice, this becomes very annoying. It is pretty common to click off a line of code before you have finished it. So getting an error message every time you do becomes annoying. There is no need to worry though, the problematic code will still turn red to let you know something is wrong.