Turn off automatic compile

Mike_Leggett
Mike_Leggett used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IN vb editor:

Tools > Options > uncheck "Auto Syntax check"
Top Expert 2006

Commented:
in vba window
go to Tools/Options

and play away!!!!!!!!
Top Expert 2006

Commented:
fefo, how many secs do u think u beat be by - both sametime, just a matter of secs, wow
ha,ha! Don't know...
but I went to vba editor to find out myself then came back to answer!
Top Expert 2006

Commented:
damn, I need some go faster stripes on my keyboard

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial