Hi Todd
you could use the Beforeprint workbook event and store a value in your
sheet (or in a static variable)

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
hey

Is it possible to count the number of times someone
printed something in a spreadhseet?

For instance lets say I in workbook "Test.xls" and
worksheet "Todd". Lets say I run the following code 5
times:

Worksheets("Wkly Renewals").Range("D7:F" & RngCounter +
2).PrintOut


If this is the case I need for the counter to keep track
and see this was my 5th time printing.


Thank you
Todd Huttenstine