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

On Tue, 2 Jun 2009 09:25:02 -0700, froggy <(E-Mail Removed)>
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?

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?

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" <(E-Mail Removed)> wrote in message
news:5E6903DC-8CAB-4452-9D11-(E-Mail Removed)...
> 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?

switch off any real time feeds

"froggy" <(E-Mail Removed)> wrote in message
news:5E6903DC-8CAB-4452-9D11-(E-Mail Removed)...
> 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?