Post the code that's used to close book2 and give the exact error msg.

HWH


"Haldun Alay" wrote in message
...
Hi,

I have one workbook (book1) which is referenced in another one (book2).
book1 is database workbook, book2 is reporting book and each workbook has
some vba codes. i wrote some codes to open book1 when book2 is opened.
also
some codes for closing routines exist.

The problem is when i try to close book2, book1 has to closed
otomatically.
but excel gives me some error messages that says -book1 is referenced in
other workbooks, closing not possible-. and leaves book1 opened.

does anybody have an idea, how can i walk around that problem.



Thanks.


Haldun