Thanks for the ideas.

Regards.

"Marcotte A" wrote in message
...
As part of the Workbook_Open event, you could use a userform to prompt the
user for all the common data. Then save the template with a new filename
[perhaps based on one of the fields just entered (eg. client name)]. To
prevent the userform from appear when the new template is opened, use an IF
statement in the workbook_open code, eg.:

If IsEmpty('client name cell') Then
'Load UserForm to get common data
'save as new template
Else
'code to execute when template with common data already entered is
opened
End If
'code to execute when original or new template is opened.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004