View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
trooper665 trooper665 is offline
external usenet poster
 
Posts: 8
Default Setting sheet.xlt for a workbook programatically

Is there any way to set one particular workbook to use a sheet.xlt template
but still have Excel generally open with a sheet template?

Basically I have a workbook.xlt template that I am using to create a new
workbook through a vb6 program. Once the program is finished running I would
like the user to be able to add a new sheet that has the same formatting as
the workbook.xlt. Is there some property that I can set that will make the
workbook.xlt use the sheet.xlt when creating a new sheet? Thanks