Excel Print Count

[SpiderBaby]

Hi All,

I looking to add a Print Count into the header of a Excel file to add up the number of time the Excel document is opened and printed.

Anyone have any ideas or macros I could use to achieve this.

Thanks a lot and appreciate any help with this..........if it's even possible

 

[hippiehacker]

here a counter for sheet1 A1

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").Range("A1") = Sheets("Sheet1").Range("A1") + 1
End Sub

 

[SpiderBaby]

here a counter for sheet1 A1

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").Range("A1") = Sheets("Sheet1").Range("A1") + 1
End Sub

That'll do it.

Thanks a million for your help with this