Are you telling me that your macros continue running when you're editing cells
in other workbooks?

And that calculation will continue in one workbook while you're busy typing away
in another?

I don't recall any version of excel that allowed that.

Calculation would always be interrupted if I did something with the
mouse/keyboard.

Doug Kanter wrote:

I'm running Excel 2000. Unless something has changed in later versions,
Excel is happy to churn things in one workbook, while you're viewing
another, all in one instance.

"Dave Peterson" wrote in message
...
I don't like to do this either. I find it a pain.

So I asked someone who asked how to do this and their reply was so that
they
could work in one instance while excel did stuff (long calculations/long
running
macro) in the other.


Doug Kanter wrote:

"Dave Peterson" wrote in message
...
If you do all your work in one instance of excel, then the copy and
paste
will
work the way you want.

Why would anyone WANT to run two instances? Is there any advantage at
all? I
see it done by mistake quite often.....

--

Dave Peterson

--

Dave Peterson