Bonjour à tous,
Ci- après un bout de code: Tout fonctionne sauf les instructions
Sheets("Accueil").Select
Range("A1").Select
Bizarre non ?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ActiveSheet.Name = ("TUNZINI") _
Or ActiveSheet.Name = ("WESTINGHOUSE") _
Or ActiveSheet.Name = ("CEGELEC") Then
Range("B29").FormulaR1C1 = "=NOW()"
Range("B29").NumberFormat = "dddd dd mmmm yyyy"" - ""hh:mm"
Range("B29").Value = "Dernière mise à jour : " & [B29].Text
Sheets("Accueil").Select
Range("A1").Select
Exit Sub
End If
MsgBox ("Pour rafraichir ... etc ")
End Sub
Ci- après un bout de code: Tout fonctionne sauf les instructions
Sheets("Accueil").Select
Range("A1").Select
Bizarre non ?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ActiveSheet.Name = ("TUNZINI") _
Or ActiveSheet.Name = ("WESTINGHOUSE") _
Or ActiveSheet.Name = ("CEGELEC") Then
Range("B29").FormulaR1C1 = "=NOW()"
Range("B29").NumberFormat = "dddd dd mmmm yyyy"" - ""hh:mm"
Range("B29").Value = "Dernière mise à jour : " & [B29].Text
Sheets("Accueil").Select
Range("A1").Select
Exit Sub
End If
MsgBox ("Pour rafraichir ... etc ")
End Sub