print jobs

  • Thread starter History of print jobs
  • Start date
H

History of print jobs

Is there anyway to see a history of print jobs for a particular document and
what date they were printed?
 
A

Ardus Petus

Create a sheet named "PrintLog",
then insert following code in ThisWorkbook.

HTH
--
AP


'----------------------------------------------------------------------------------------
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Worksheets("PrintLog")
.Cells(Rows.Count, "A").End(xlUp).items(2).Value = Now
End With
End Sub

'----------------------------------------------------------------------------------------
"History of print jobs" <History of print [email protected]> a
écrit dans le message de [email protected]...
 
H

History of print jobs

I apologize. Could you be a bit more specific? The document of interest is
in excel format. I really appreciate your help.
 
A

Ardus Petus

In your workbook:
insert>Worksheet
Click to expand...
right-click on new tab, select rename
enter PrintLog as new sheet name

Right-click on Excel icon on top left cornet of you workbook window
select View code

In the newly opened window, paste the code I sent you.

Get back to excel and test the new macro (print your workbook)

HTH
 
Top