automatic counter or auto-increment
 

I'd like to have a counter where each time I access a worksheet (ExcelXP) it increments by one (just like the ol' Invoice in Excel 2000 and 97) or each time I send it to print (this would be even better). Any ideas?

automatic counter or auto-increment
 

use the BeforePrint event to increment a counter stored in a defined name or
in a cell. To be successful, you would need to save the file after you
updated the counter.

--
Regards,
Tom Ogilvy
"Jjt" wrote in message
...
I'd like to have a counter where each time I access a worksheet (ExcelXP)
it increments by one (just like the ol' Invoice in Excel 2000 and 97) or
each time I send it to print (this would be even better). Any ideas?