Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim Lig As Long, Col As Long
Col = Target.Column
Lig = Target.Row
With Target
If .Column = 2 Then
Cancel = True
If .Comment Is Nothing Then
.AddComment
.Comment.Shape.Width = 160.5
.Comment.Shape.Height = 60.5
.Comment.Shape.TextFrame.Characters.Font.Bold = True
End If
SendKeys "%im"
End If
End With
Target.Offset(0, -7).Interior.ColorIndex = 4
End Sub