Are you thinking of Word where there is a Normal.dot file. XL has nothing
similar...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

What do you mean by default template??? That line of code copies the sheet
with tab name "sheet1" from the active workbook to a new workbook.
--
HTH...

Jim Thomlinson


"Little Penny" wrote:

Sheets("sheet1").Copy

This line of code copies the sheet1 to a new workbook useing the
default template. Is there a way to put into the code and tell excel
which template to use.

I want to avoid changing everyone default template.