Bonjour PyranaS9, le forum,
Peut-être ainsi:
If .Column >= 7 Then
If .Column <= 7 Then
revient à dire
If .Column = 7 Then
non ?
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
With Target
If .Column = 7 Then
Cancel = True
If .Comment Is Nothing Then
.AddComment
.Comment.Shape.Width = 104.5
.Comment.Shape.Height = 150.6
.Comment.Shape.TextFrame.Characters.Font.Bold = True
End If
SendKeys "%im"
End If
End With
Cancel = True
End Sub
Cordialement,
PS: Le clic droit est-il judicieux ? Comment fais-tu si tu souhaites supprimer le commentaire?