automatic counter or auto-increment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
I'd like to have a counter where each time I access a worksheet (ExcelXP)
Click to expand...
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?
 
Back
Top