Invoice numbers

[JB]

How can I get invoice numbers to change automatically
when opening invoice without having to do it manually??

 

[Paul B]

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 **

 

[Andy Brown]

Do you mean invoice.xlt, the Village Software template?

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

Rgds,
Andy