Require a process to obtain sequential numbers.
To run indepentantly on each salesmans machine.
To have a method where salesman has to input His/Her initals, which then
forms the prefix of the contract number.
The contract numbers to be used by about 12 different contracts, by each
salesman, so attaching to each workbook is not an option.
I would send each salesman a file called SeqNum.xls, to be put into the same
directory on everyones machine: c:\Excel Add_Ins\SeqNum.xls.
I would attach a menu item to the special menu tree that I send to each
person.
This menu item (Contract Number) would be triggered to activate the use of
the next number.
I can't have it issue a number each time it is opened, or each time it is
closed.

My skill is so low, I cannot get anywhere with the McGimpsey example that
many sites are directed too. I get a "feel" for what it is to do, but don't
understand how (and where) to set it all up and how to actually activate it.
Jasion Morin example of entering the salesman name works great, but does not
meet my other requirements, as far as I can tell.
Any detailed help would be greatly appreciated.
I'm at my wits end and the pressure is being brought to bear. (not fair, but
what can I do)
thanks in advance.