When you have VB Editor closed, and you run the macro from "Tools", "Macros",
VB Editor should never pop up by itself unless the macro encounters an error
and you chose to switch to debug mode.
Of course, when you run your macro from VB Editor by clicking on the "play"
button, VB Editor would remain active in the screen.
Otherwise, I cannot think of any circumstances or reason why VB Editor would
pop up by itself. I simply have never seen this happening...
Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com