anthoYS
XLDnaute Barbatruc
Bonjour,
Merci
à+
VB:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)With Target
If .Column = 3 Then
Cancel = True
If .Comment Is Nothing Then
.AddComment
.Comment.Shape.Width = 48
.Comment.Shape.Height = 12
End If
SendKeys "%im"
End If
End With
If Not Application.Intersect(Target, Range("A:A")) Is Nothing And IsEmpty(Target) Then
Calendrier.Show
End If
End Sub
Merci
à+
Pièces jointes
Dernière édition: