I am assuming that you mean a toolbar button when you say "Icon". S
what you want is a button that you press that will give you the nex
available number, yes?

If so you could simply make a seperate workbook called "Invoice Number
that has one sheet only and in that sheet you have a "Current Number
cell and a "Last Number" cell. You would then make a macro that open
the Invoice Number workbook, grabs the Current Number, puts it in th
Last Number cell, then adds 1 to the Current Number, pastes that valu
in your workbook that is open and waiting for that number, the
replaces the Current Number in the Invoice Number workbook, saves i
and closes it.

After you make that macro, you would assign it to a toolbar button.

Just one idea, anyway

Rees Macleo

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements