Just create a new macro to do that for you?
You can simply use te existing number, and add 1 to it, or you can store the
number in the registry.
I find that using the existing number is effective, and easy.
Create a variable, sy vNumber as variant. Say your number is located in C5.
Write the folowing macro
Sub Number()
vNumber = Range("C5").value
vNumber = vNumber + 1
Range("C5").value = vNumber
End Sub
Create a button, and assign the macro to it

--
HTH

Kassie

Replace xxx with hotmail


"Angela Rose" wrote:

I have been using a template created in Excel 2000 for my business invoices
for 7 years. This template had a tool box which allowed me to assign a
sequential new number for each invoice automatically by clicking assign new
number. Is this feature available in Excel 2007? I have tried enabling
macros which were used on the previous version, but each time I attempt to
run them, I get the message "The numbering add-in must be loaded for optimal
numbering and toolbar behavior. Please load this add-in into your Library
Directory." Where do I find this add-in? It is not located in Excel 2007 and
I cannot find it on available downloads on Microsoft web-site... which is
where I am directed from the help menu. PLEASE HELP!!