I've created an invoice template for a business I'm starting up, and notice
that in Office 2000's templates their invoice lets you assign a unique
number. I presume it's a macro, but don't know much about writing visual
basic.

Can't you modify that template? Then you will have that functionality.

To do it on your own could be complex if you are not familiar with Visual
Basic.

You could just keep a separate sheet where you have the numbers, and do a
copy and paste to your invoice sheet. It isn't automatic, but maybe easier
to maintain.

--
Regards,
Tom Ogilvy

"Feltonblue" wrote in message
...
I've created an invoice template for a business I'm starting up, and
notice
that in Office 2000's templates their invoice lets you assign a unique
number. I presume it's a macro, but don't know much about writing visual
basic.

Thanks for the quick reply.
I can't get at the macro used in the sample template - it's password
protected - otherwise I'd have just copied it. Looks like I might just have
to do it manually.

David

"Tom Ogilvy" wrote:

Can't you modify that template? Then you will have that functionality.

To do it on your own could be complex if you are not familiar with Visual
Basic.

You could just keep a separate sheet where you have the numbers, and do a
copy and paste to your invoice sheet. It isn't automatic, but maybe easier
to maintain.

--
Regards,
Tom Ogilvy

"Feltonblue" wrote in message
...
I've created an invoice template for a business I'm starting up, and
notice
that in Office 2000's templates their invoice lets you assign a unique
number. I presume it's a macro, but don't know much about writing visual
basic.

I doubt it would be that easy to just copy it. I suspect that a lot of the
code is in a compiled DLL. But what I was suggesting was using the
template provided with excel since that can be modified.

--
Regards,
Tom Ogilvy

"Feltonblue" wrote in message
...
Thanks for the quick reply.
I can't get at the macro used in the sample template - it's password
protected - otherwise I'd have just copied it. Looks like I might just
have
to do it manually.

David

"Tom Ogilvy" wrote:

Can't you modify that template? Then you will have that functionality.

To do it on your own could be complex if you are not familiar with
Visual
Basic.

You could just keep a separate sheet where you have the numbers, and do
a
copy and paste to your invoice sheet. It isn't automatic, but maybe
easier
to maintain.

--
Regards,
Tom Ogilvy

"Feltonblue" wrote in message
...
I've created an invoice template for a business I'm starting up, and
notice
that in Office 2000's templates their invoice lets you assign a unique
number. I presume it's a macro, but don't know much about writing
visual
basic.