Please try Workbook_Open() and Workbook_BeforeClose events....

If this post helps click Yes
---------------
Jacob Skaria


"Lost" wrote:

i would like to open it when the parent opens

"preymond" wrote:

You can use the auto_close() function in VB to close automatically the
workbook when you close the parent once. When do you want to open the 2nd
workbook ?