Compile Editor Warning

[Darth Vodka]

is there any way of switching off the really annoying

"Compile error" when you get the syntax wrong and it colours the line red

i just want to be able to move about copying and pasting without having the damn pop up

 

[ecawilkinson]

In the VBA editor, go to Tools>Options, then under the "editor" tab, untick Auto Syntax Check.

 

[Darth Vodka]

i should have really figured that out

many thanks