Invoice numbers

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

How can I get invoice numbers to change automatically
when opening invoice without having to do it manually??
 
JB, here is a way to do it on open, or you could use something like it an
assign it to a button, or another event like before print or before save.

Private Sub Workbook_Open()
Sheet1.[A1] = Sheet1.[A1].Value + 1
End Sub
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Do you mean invoice.xlt, the Village Software template?

The VB project is protected, you'd have to hack it.

Rgds,
Andy
 
Back
Top