Thanks

It seems to try and work, but I'm getting a message saying that macro's are
disabled because of a high security level and I can either lower it or
request that macros be digitally signed... What security? In excel or a
firewall or what?

Also, I forgot to meantion that in another cell the invoice number has to
appear. The cells are E 1 and E 19. Do I have to make two macro's?

John

"L. Howard Kittle" wrote:

Hi John,

Have a look here, J.E. has it figured out quite nicely.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

HTH
Regards,
Howard

"John" wrote in message
...
Hi,

I'm having a lot of issues here understanding how to use a the macro's
with
an Excel 2003 workbook.

The scenario is to create an invoice and each must have a different
invoice
number which will be incremented by 1 each time I use the workbook. I'll
actually want to save-as the workbook to a new one per invoice.

I spent the afternoon reading threads and trying out various macro's and
got
myself totally lost. In the end I deleated the workbook which had about
10
different macro's in it. I'd like to just start all over from scratch.
The
invoice itself isn't complicated and can be drawn up in 10 minutes, it is
just increasing the invoice number that I have trouble with.

I'd like to know why MS didn't just include this.. it has everything else.