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