Sub TaMacro()
Application.ScreenUpdating = False
Application.Calculation = xlManual 'Recalcul manuel
'-----------------------------
' TA MACRO ICI
'-----------------------------
Application.Calculation = xlAutomatic 'Recalcul automatique
Application.ScreenUpdating = False
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [AT3,AT4:AW4]) Is Nothing Then Exit Sub
Dim etat As Boolean
With Application
.ScreenUpdating = False
.Calculation = xlManual
.DisplayAlerts = False
etat = .AskToUpdateLinks
.AskToUpdateLinks = False
Workbooks.Open(ThisWorkbook.Path & "\a-mmg\MMG Raport TBS - BASE.xlsm").Close True
.AskToUpdateLinks = etat
.Calculation = xlAutomatic
.ScreenUpdating = True
End With
ThisWorkbook.Save
End Sub