I think so.

If you just try a macro with simple endless loop, I think you'll see the
difference.

Option Explicit
Sub testme()
Dim i As Long
Dim j As Long
For i = 1 To 1000000000
j = i + 1
Next i
End Sub

Hit ctrl-break to get out of it.

Doug Kanter wrote:

From what I can tell, yes, although I don't have macros than run for more
than perhaps 30 secs. Could this be an error in perception?

"Dave Peterson" wrote in message
...
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

--

Dave Peterson