code trying to run while typing

[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?

 

[Gord Dibben]

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

 

[Gary Brown]

While in the VB Editor, from the top menu, select TOOLS, OPTIONS.
Go to the 'Editor' tab.
Uncheck the 'Auto Syntax check' checkbox

 

[Tim Zych]

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.

 

[Patrick Molloy]

switch off any real time feeds