Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Application.ScreenUpdating = False
If ActiveCell.Column = 4 And ActiveCell.Row >= 3 Then
品名.Show
End If
Application.ScreenUpdating = True
End Sub
改成
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If ActiveCell.Column = 4 And ActiveCell.Row >= 3 Then
品名.Show
End If
End Sub