automatic numbering as in invoicing but for certificates

[certificatelady]

I need a new number for every time I open a an excel template I have made for
certificates. Any ideas?

 

[Don Guillett]

Put a macro in the Workbook_open event of the ThisWorkbook module

 

[Eduardo]

Hi,
Take a look at MCGimpsey web

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

If this helps please click yes, thanks