Search:

Thanks for your response. I did find a way to do it in VBE. With the following code:
Sub auto_open()
On Error Go to ErrorCatch
Cells(9, 13) = Cells(9, 13) + 1
If Cells(9, 13) = 10000 Then...

Is there a way within Excel to Auto Generate a new number every time I open a spreadsheet.ie: I made a Purcahse Order template and I would like for Excel to generate a new Purchase Order number...