I think this is a fairly common request.

see (watch for wrapping):
http://groups.google.com/group/micro...+number&qt_g=1
for a list of (some of the) responses from the generous people of this NG.

Without knowing more about your own requirements I can't really comment
- it depends on whether people will be using (indeed able to access( the
same workbook, template, network drive etc. Everyone, anywhere is a tall
order. How does someone running on a standalone laptop know what
invoices other people are generating? You could preface invoice numbers
with someone's initials maybe?

I'm sure the above link should point you in the right direction.

HTH

Vestmc wrote:
I have created my own invoice. I need a counter that automaticly counts 1
number op after printing the invoice. I schould be able to shot down the
computer an turn it of without that special number disapers. I need some kind
of of a macro to put into a cell in exel where a have created my invoice. It
has to be a macro that can be used by everyone anywhere. I havent found one
on the net yet. Funny that no one has given it a thougth that it migth be
needed. ANYONE OUT THERE WHO CAN HELP ME ?????????????

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming