Create a new workbook with one sheet and format as you wish.

FileSave AsFile TypeTemplate(*.xlt)

Name it SHEET(Excel will add the .xlt extension.

Store this SHEET.XLT in your XLSTART folder.

It will be the default worksheet for InsertWorksheet.


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 17:29:01 -0800, Nukinhawg
wrote:

I need to use the format of an Excel spreadsheet that I have created as a
template for other worksheets in a book and other books. How can I accomplish
this, if possible?