Hi All

I currently have a problem with a program I have (well
that's why we write here now)

What happens is one workbook opens another workbook and
then the original workbook is closed. However when I do
this because the code originated in the original workbook
as soon as it is closed I get an object-defined error.
That is to say the code can not continue to execute as I
have removed the root macro that is running the operation.

Does anyone know how to get around this?

Thanks in advance
Jase