Doco ... thanks for the info ... I understand the process. But that is now
what is happening.
When I open the file names pform.xlt I expect the file to say at the top
"pform1" but instead it says pform.xlt. Thus Excel is not recognizing the
file as a template.
Below is the name of the file copied from the
VB immediate window:
?activeworkbook.Name
PFORM.xlt
Any more thoughts?
Stewart Rogers
"doco" wrote:
What do you mean by "save over"? After creation and saving a template as
*.xlt and re-opening it, then saving the file again, the default process is
for the CommonDialog to appear and prompt to save as *.xls unless you make a
file type selection different from that and at that time. It will not
overwrite your original *.xlt file.
HTH
doco
"Datasort" wrote in message
...
I have saved an xl file as .xlt extention. When I open up the file it is
not
in templete mode. I am about to save over the templete.
Can you tell me what I am missing
Regards,
Stewart Rogers