You could add some code to test whether the date is the 1st and reset to
one, but is it possible that the workbook is opened more than once in a day?

BTW, which version are u using, registry or text file?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"abcdexcel" wrote
in message ...

Hi

I have got the code for sequential numbers from McGimpsey's website. Is
there a code, that the numbers restart on every change in month.

Thanks
SAS


--
abcdexcel
------------------------------------------------------------------------
abcdexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30021
View this thread: http://www.excelforum.com/showthread...hreadid=501060