would you please show me exactly i could adapt that.
what would that do...or accomplish??

i went to the web site and saw the example. i'm think
i could copy that into a macro....is that what it is??

i know enough to be dangerous...but have limited skills.

thanks!

"JE McGimpsey" wrote:

One way:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

You could adapt the Workbook_Open() code to another event (e.g.,
BeforePrint, BeforeSave)


In article ,
Carrie wrote:

I'm looking for a way to develop receipts for cash and checks.

I want the receipt # to go up by one (after printing or saving) so
that it is a good audit control (and theft preventive).

I would be the one in control of the spreadsheet.
Others would receiving the cash...I never do that.

Any suggestions...macros....etc???

THANKS in advance