I have just upgraded from Office 2000 to Office 2007. In Excel 2000 I was 
able to insert a unique invoice number automatically by clicking "add number" 
on the invoice toolbar. Can a similar action be taken in Excel 2007 and, if 
so, how do I set it up?  Thnaks for any help,

Ian

Perhaps you need to include an equivalent add-in to what you added to Office 
2000?  There isn't an "invoice toolbar" in native Excel.

It sounds as if using the same add-in isn't trivial:
http://www.officekb.com/Uwe/Forum.aspx/ms-excel/93002/Excel-Invoice-Template
--
David Biddulph

IDJ&A wrote:
> I have just upgraded from Office 2000 to Office 2007. In Excel 2000 I
> was able to insert a unique invoice number automatically by clicking
> "add number" on the invoice toolbar. Can a similar action be taken in
> Excel 2007 and, if so, how do I set it up?  Thnaks for any help,
>
> Ian

I can confirm that the Template Utilities Add-in does work with the
INVOICE.XLT from Excel 2000 if that is the Template you were/are using.

You need a copy of TMPLTNUM.XLA which was not provided with versions newer
than 2000

If you email me I can send you an unpassworded copy of the Add-in.

gorddibbATshawDOTca               change the obvious.


Gord Dibben  MS Excel MVP

On Mon, 15 Feb 2010 22:24:09 -0800, IDJ&A <IDJ&A@discussions.microsoft.com>
wrote:

>I have just upgraded from Office 2000 to Office 2007. In Excel 2000 I was 
>able to insert a unique invoice number automatically by clicking "add number" 
>on the invoice toolbar. Can a similar action be taken in Excel 2007 and, if 
>so, how do I set it up?  Thnaks for any help,
>
>Ian