count the prints

[waqar571]

how can we count the number of prints taken for a sheet in a cell.

 

[oldbrewer]

can you please explain further....

 

[waqar571]

we have an excel sheet, people take prints of the data we have in that sheet. we would like to count the number of prints taken for the sheet in a cell. first print would be 1, if one more print taken it will add into it and the counter would be increased.

 

[oldbrewer]

use a macro activated by a shape labellled click here to take a print, and each time a counter is increased by 1 and displayed in a cell of your choosing. But easy to bypass this eg open a read only copy and print from that...

 

[wideboydixon]

Use [Alt]+[F11] to bring up the VBA editor then double-click on the ThisWorkbook object. Paste the following:

Private Sub Workbook_BeforePrint(Cancel As Boolean)

With Sheets("Sheet1").Range("A1")
    .Value = .Value + 1
End With

End Sub

Change "Sheet1" and "A1" to match your sheet name and cell reference.

WBD

 

[waqar571]

Thank you. it's working, how can we achieve this in word.