Insert auto serial number in Excel template

I don't now how to insert new auto serial number or couter every time when
the template is opened

Hi,

What I did once was similar, check out "CustomDocumentProperties". You can
add a "Serial number" property there and most users aren't even aware of it.
It can be installed and retrieved in code automatically, but you would need
to store some type of counter in your program file.

Custom document properties are visible by going to [File] then [Properties]
then click on the [Custom] tab. You can write auto-open event code to
increment a counter, version number or whatever.

Hope this helps.

"Van Gel" wrote:

> I don't now how to insert new auto serial number or couter every time when
> the template is opened