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?