Salut DoreID,
à tester
Private Sub Workbook_BeforeClose(Cancel as Boolean)
Windows("C-CLIENT.xlsm").Activate
ActiveWorkbook.Close SaveChanges:=True
End Sub
ou comme ca:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Option Explicit
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call fermerWB
End Sub
Dans un Module:
Sub fermerWB()
Windows("C-CLIENT.xlsm").Activate
ActiveWorkbook.Close SaveChanges:=True
End Sub
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
@++