automatic numbering as in invoicing but for certificates
 

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

automatic numbering as in invoicing but for certificates
 

Put a macro in the Workbook_open event of the ThisWorkbook module

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"certificatelady" wrote in
message ...
I need a new number for every time I open a an excel template I have made
for
certificates. Any ideas?

automatic numbering as in invoicing but for certificates
 

Hi,
Take a look at MCGimpsey web

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

If this helps please click yes, thanks

"certificatelady" wrote:

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