There are however a few alternatives.

One is... but from your description I don't think it would work  for you.. is
to openn multiple windows on your desktop so the applications are run but
you can still see the VBE window.

By far the best solution is to use multiple monitors. Put an extra video
card in and run the VBA in that while the "action" stuff goes on on the
other monitor.

This means putting an extra card in but that's no biggie.

Windows by default has support for a total of 9 extra monitors.

If you have an old monitor "hanging around" and more impotantly if you have
the desk space... apart from being cooooool... I wouls advise you to go the
extra monitor way. The minimum you gert is that you can do reeeeeeeeeal wide
spreadsheets!