code trying to run while typing

  • Thread starter Thread starter froggy
  • Start date Start date
F

froggy

While I am typing code in the Visual Basic Editor, the macro trys to run. I
will be in the middle of a line and suddenly I get an error.

How can I stop this from happening?
 
What type of error and are you sure the macro is actually trying to run?

Could be it is Excel flagging bad syntax?


Gord Dibben MS Excel MVP
 
While in the VB Editor, from the top menu, select TOOLS, OPTIONS.
Go to the 'Editor' tab.
Uncheck the 'Auto Syntax check' checkbox
 
Another guess (hard to tell based on your description). If you are using
Bloomberg's Excel addin or other addin which is running in
the background, this may be why. If so, disable it while you write code, as
it messes up the development environment and leads to compilation errors.
 
Back
Top