• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

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
0
Mike_Leggett
Asked:
Mike_Leggett
  • 3
  • 2
1 Solution
 
fefo_33065Commented:
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now