View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Saving a template as a worksheet

It might be easier to use windows explorer to mark your file as ReadOnly.

Then if you open that template file, you won't be able to write over it.

But if you use create a new workbook based on that template, you'll still be ok.

ps. If you store your .xlt file in your template folder, you'll be able to use
File|new and create a workbook based on that template.

Leon wrote:

When I open a template worksheet
After I'm done working on it Is there a way to have the default file type
changed from xlt to xls when I save it.
I'm asking this question because I sometimes forget to change the file type
and my worrksheet is saved as my template instead of as a new worksheet with
the attributes of the template.
Thanks in advance for any help


--

Dave Peterson