Hi Nigel,

As I read your requirements, no code would be required.

To set up an Estimates template sheet:

Open a new workbook
Copy (or create) a sheet with the estimate form.
Set all of the form / sheet formats as desired.
Delete all the remaining sheets.
File | SaveAs | File Name: 'Estimate Sheet' | Save as type: Template(*.xlt)
| Save

Once created and saved, the template sheet can be added to any workbook
(right-click the worbook tab | Insert)

If, rather than a single template sheet, you require a template workbook,
retain/add any sheets you need, add any required formats and data. Save as
above with a suitable identifying name.

---
Regards,
Norman



"Nigel" wrote in
message ...

Hi Norman and thanks for the reply.

If the truth is known havent been able to use the template solution
because I cant figure out the VB script needed to do it and thought
there might be an easier way. I did try but got a "syntax" error on the
address line (which I know was correct as I tried the same address in a
hyperlink and it worked fine). If you could give me a script example it
would be a great help.

Regards and thanks

Nigel


--
Nigel
------------------------------------------------------------------------
Nigel's Profile:
http://www.excelforum.com/member.php...o&userid=25696
View this thread: http://www.excelforum.com/showthread...hreadid=391122