vba editor comes up everytime this specific macro is run

[mithu]

sorry if this is a repost.. when i clicked on the one i put up earlier
i think because it included code it got deleted.

here is what is happening.. i have a module that has a set of code.

for some reason whenever i run the main macro the vba editor also
comes up.. there is no errors or any debug breakpoints.. the code runs
fine.. just the vba editor comes up everytime i run it..

any one know why?

 

[JNW]

If you close all the way out of Excel the reopen the file and run the macro
does it still do it?
If so, if you restart the computer and the run does it do it?

 

[Bob Flanagan]

Could you post the code? Is the code sending any keystrokes? Try putting
an"end" statement in various places in the code until you isolate the line
of code that is triggering the vbe from appearing.

One thing to try in the vb editor is to assign a password to the project and
hide it from viewing. Select in the vbe Tools, Porject Properties,
Protection. Sometimes locking the code prevents such strange behavior.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel