"mp" wrote in message
...

<...

Thanks Clif
i thought of that but my thinking was that
since focus does move to new document,
and since code was started in first document
that code would not continue after first document had lost focus...
but i'll give it a try
thanks
mark



The code continues ... in fact, as far as VBA is concerned the code and
the worksheet are not even related ... they may be, or they may not be
..... which is why eventually the programmer needs to learn
disambiguation .... which I'm still learning <grin.

ThisWorkbook refers to the workbook the code is running in,
ActiveWorkbook refers to the workbook with focus. Take note of Garry's
reference to using objects to refer to the two different workbooks in
his reply.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)