I viewed a response about auto number roll over in excel from Roger and Paul
B, like this:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1
End Sub

This is absolutely great. But, of course, I need to know if there's a way
to include a pop up that e-mails or at least retains certain information
about who did a "save as" on the form and what number it gave them.

I'm working on a purchase order form that is available to multiple
individuals. It needs to assign a new purchase order number (in increments
of 1 - like 001, 002, 003). But, from an administrative standpoint, we need
to know who got the PO number. I'm thinking something like a pop up window
that asks for user name and notes the PO number.

Am I dreaming or is this possible?

Thanks so much for any help I receive!