Actually the code I provided won't work properly in the Template.

I sort of misread your post<g

The code just prevents the number from updating in the workbook created from
the template when next opened.

You need something like code from John McGimpsey's site to first increment
the number from the template.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord

On Fri, 26 Dec 2008 08:53:01 -0800, Riker1074
wrote:

Gord,

Would that code work in a template (.xlt) file as well? I've tried various
methods in the past and had all but given up.