Hi Matt,

I see what you mean now. When the called WB closes, the code thread is lost
with it, so the original code does not continue. Don't think there is much
you can do about that other move the code that is in the child workbooks
from the Workbook_Open event to an Auto_Open macro because Auto_open doesn't
fire when a workbook is opened from code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matt" wrote in message
...
Sorry (That confused me too when I read it back)

I have a main workbook and it has a routine which opens other workbooks in
sequence.

Workbooks.open("Workbook1")
Workbooks.Open("Workbook2")

etc

In the Open event of each of these workbooks is a routine. If you don't
put code to close/save these workbooks at the end of the routine then each
workbook opens OK. If you place code to close and save the workbooks at the
end of the routine then the routine in the main book doesn't go any further.

Thanks,
Matt