Allan, where every you are storing the number in the macro just change it
back to to 0 there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allan" wrote in message
...
I have just setup an 'order' template in excel and inserted a macro that
increments the number when opened.
I have tested the workbook and I now wish to reset thenumbering system
back
to 0 (zero).
Can anyone advise me how I proceed.
Allan