Hi Samuel,

OK, two workbooks (BookA.xls and BookB.xls). When BookA is closed you want to force BookB to close (and save changes, for example)

If you add the following code to ThisWorkbook module in BookA.xls

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Call Workbooks("BookB.xls").Close(True)
End Sub
Works for me. No doubt you will need to do some other checking etc.

Hope that helps.

cheers

Malcolm