Turn off automatic compile

Posted on 2006-06-14
Last Modified: 2010-05-18
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
Question by:Mike_Leggett
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Accepted Solution

fefo_33065 earned 250 total points
ID: 16903634
IN vb editor:

Tools > Options > uncheck "Auto Syntax check"
LVL 65

Expert Comment

ID: 16903637
in vba window
go to Tools/Options

and play away!!!!!!!!
LVL 65

Expert Comment

ID: 16903652
fefo, how many secs do u think u beat be by - both sametime, just a matter of secs, wow

Expert Comment

ID: 16903692
ha,ha! Don't know...
but I went to vba editor to find out myself then came back to answer!
LVL 65

Expert Comment

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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question