Turn off automatic compile

Can I to turn off the automatic check on vba code.  I want to be able to compile when I say and not to get the irritating message compile error when I move away from the line to fetch something.  Even better would be the text to show red but no messaqe
Mike_LeggettAsked:
Who is Participating?
 
fefo_33065Connect With a Mentor Commented:
IN vb editor:

Tools > Options > uncheck "Auto Syntax check"
0
 
rockiroadsCommented:
in vba window
go to Tools/Options

and play away!!!!!!!!
0
 
rockiroadsCommented:
fefo, how many secs do u think u beat be by - both sametime, just a matter of secs, wow
0
 
fefo_33065Commented:
ha,ha! Don't know...
but I went to vba editor to find out myself then came back to answer!
0
 
rockiroadsCommented:
damn, I need some go faster stripes on my keyboard
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.