code trying to run while typing
 

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?

code trying to run while typing
 

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

On Tue, 2 Jun 2009 09:25:02 -0700, froggy
wrote:

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?

code trying to run while typing
 

While in the VB Editor, from the top menu, select TOOLS, OPTIONS.
Go to the 'Editor' tab.
Uncheck the 'Auto Syntax check' checkbox
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"froggy" wrote:

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?

code trying to run while typing
 

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.

--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

"froggy" wrote in message
...
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?

code trying to run while typing
 

switch off any real time feeds

"froggy" wrote in message
...
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?