Hi John

I have no time on this moment but will look at it this evening



--
Regards Ron de Bruin
http://www.rondebruin.nl


"JzP" wrote in message oups.com...
Hi Ron,
Many thanks for such a rapid response.

I've looked at the article but still have another question.

I'm sorry if I'm being a bit dim here but what I'm doing at the moment
is running BookA and copying sheets from one of the 5 other workbooks
into BookA. Then all the code in BookA runs and manipulates the data
and finally copies the correct output sheets into, say, BookOut.
BookA thus starts with about 6 sheets in it, has perhaps 50 sheets of
data copied into it, creates another 50 and writes out the created
sheets to the output file. Then the code in BookA deletes all the data
and created sheets.
The user then makes a new selection on the top sheet in BookA and the
whole process starts again.
Because I'm copying into BookA I can't close BookA periodically from
itself, or should I be doing that from the second excel workbook which
I've tried in order to run BookA?
I hope that hasn't just confused matter more!
Thanks again.

John