You could add a 1 to Sheet1!A1 each time the workbook is
opened. Press ALT+F11, double-click the "ThisWorkbook"
module under ViewProject Explorer and paste in:
Sub Workbook_Open()
With Sheets("Sheet1").[A1]
.Value = .Value + 1
End With
ActiveWorkbook.Save
End Sub
--
HTH
Jason
Atlanta, GA
-----Original Message-----
I created a template for a purchase order in Excel.
Everytime someone opens
the template, I would like one cell to be automatically
numbered in a
sequential pattern. That way each time the template is
used, it will have
it's own unique number that will be used to identify
it. Does anyone know if
this is possible for Excel 2000?
Thanks!
.
|