Tracking Number of Times You Print a Spreadsheet

  • Thread starter Thread starter Bryan Hill
  • Start date Start date
B

Bryan Hill

Does anyone know the VB code (or maybe another method) fro
creating a macro or some other function that would record
the number of times a worksheet is printed?

Basically, I need to know how often a certain spreadsheet
is printed for my boss and don't want to have to keep a
manual field that I update with the number +1 everytime I
print it....can this be automated? So that every time I
print the spreadsheet the value in this cell is
incremented by one?

Please reply to (e-mail address removed) if you have a
quick and easy solution. I am assuming this requires some
minor VB code and a macro, but have no idea how to get
started to make it work.

Bryan Hill
7/11/2003
 
I'm not sure if it's important, but if you don't do a save after this, that
value put into A1 will be lost.

And if you print copies=20, did you want to add 20 to your count?

I think if I cared about this kind of stuff, I'd build a little macro that asked
me how many, did the print, and updated the cell and saved the workbook.

(And remember not to use ctrl-P or File|print or the Print icon or the print
preview icon and the print button there.....whew, lots to remember!)
 
Back
Top