How do I set up a template to assign a unique number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i set up auto number in excel? 2
Auto Assigning Number to Excel Invoice 5
User authentication/protection 1
invoice toolbar for invoice calcuation and assign number 16
template creates invoice - how to create summary worksheet? 13
Assigning a Unique number 3
How do I set up an automatic invoice number in Excel 2007 1
ThisWorkbook.SaveAs not saving correctly 2

Back
Top