不执行“打印”模块
Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击单元格执行
If T.Column = 1 And T.Row > 1 And T.Row <= Sheet2.Range("A65536").End(xlUp).Row Then
If T <> "" Then
Sheet3.Range("B1") = T
Call 记录
Call 打印
End If
End If
Application.SendKeys "{Esc}"
End Sub
执行“打印”模块
Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击单元格执行
If T.Column = 1 And T.Row > 1 And T.Row <= Sheet2.Range("A65536").End(xlUp).Row Then
If T <> "" Then
Sheet3.Range("B1") = T
Call 记录
' Call 打印
End If
End If
Application.SendKeys "{Esc}"
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击单元格执行
If T.Column = 1 And T.Row > 1 And T.Row <= Sheet2.Range("A65536").End(xlUp).Row Then
If T <> "" Then
Application.ScreenUpdating = False
Sheet3.Range("B1") = T
Call 记录
Call 打印
Application.SendKeys "{Esc}"
End If
End If
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击单元格执行
If T.Column = 1 And T.Row > 1 And T.Row <= Sheet2.Range("A65536").End(xlUp).Row Then
If T <> "" Then
Application.ScreenUpdating = False
Sheet3.Range("B1") = T
Call 记录
Call 打印
Application.SendKeys "{Esc}"
End If
End If
End Sub
爱疯 发表于 2015-9-25 09:54
Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击单元格执行
I ...
从语句上看没问题,但运行起来还是老样子,不执行“打印”是可以的,请老师运行测试一下,谢谢!!!
Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击单元格执行
If T.Column = 1 And T.Row > 1 And T.Row <= Sheet2.Range("A65536").End(xlUp).Row Then
If T <> "" Then
Application.ScreenUpdating = False
Sheet3.Range("B1") = T
Call 记录
'Call 打印 ' 这句不执行是正常的,但执行了就不行了
Application.SendKeys "{Esc}"
End If
End If
End Sub