I've just taken over maintenance of some pretty scary legacy vba at work. When I have spare time I'm essentially restructuring and rewriting it in new templates. Every now and then, I've managed to exploit a glitch of sorts and have two different instances of the VBE open at once. I don't know exactly what I did to make this happen, but it makes my life much easier, so I'm wondering if anyone else knows. I assume it's something to do with running Word as a new instance, but I can't change my file type settings on my work PC.
Edit: I usually copy and paste into Excel and do it this way, but this is not ideal because I also use a lot of Excel macros for other parts of my job