如题所述
Dim printTimes As Long
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets(1).Cells(Format(Date, "D"), "A") = printTimes
End Sub
Private Sub Workbook_BeforePrint(Cancel As Boolean)
printTimes = printTimes + 1
End Sub
Private Sub Workbook_Open()
'ç¨sheet1æ¥åå¨æå°è®°å½
printTimes = Val(Sheets(1).Cells(Format(Date, "D"), "A"))
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets(1).Cells(Format(Date, "D"), "A") = printTimes
End Sub
Private Sub Workbook_BeforePrint(Cancel As Boolean)
printTimes = printTimes + 1
End Sub
Private Sub Workbook_Open()
'ç¨sheet1æ¥åå¨æå°è®°å½
printTimes = Val(Sheets(1).Cells(Format(Date, "D"), "A"))
End Sub
温馨提示:答案为网友推荐,仅供参考
第1个回答 2016-07-09
workbook打印事件里记录