Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
Hi There,
Does a Template SHEET exist? Is it possible to "pre-define" a worksheet? So that when you click: InsertWorksheet you get your Template Worksheet?, instead of the standard Blank. If you right-click your sheet: Insert... you can select a Template to insert. That's already something. But is it possible to change the standard Worksheet to my own "Template worksheet"? Brgds Sige |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
create a workbook with your single sheet template and name it Sheet.xlt and
place it in your xlstart directory. -- Regards, Tom Ogilvy "Sige" wrote in message oups.com... Hi There, Does a Template SHEET exist? Is it possible to "pre-define" a worksheet? So that when you click: InsertWorksheet you get your Template Worksheet?, instead of the standard Blank. If you right-click your sheet: Insert... you can select a Template to insert. That's already something. But is it possible to change the standard Worksheet to my own "Template worksheet"? Brgds Sige |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
Hi Sige,
Create a single sheet workbook. Set up the sheet to meet your requirements, Save the sheet, selecting Template)*.xlt) from the 'Save as type' dropdown. Save the sheet with a descriptive name. If you want to change the default worksheet, save the template sheet as Sheet.xlt, saving it in the XLStart folder. --- Regards, Norman "Sige" wrote in message oups.com... Hi There, Does a Template SHEET exist? Is it possible to "pre-define" a worksheet? So that when you click: InsertWorksheet you get your Template Worksheet?, instead of the standard Blank. If you right-click your sheet: Insert... you can select a Template to insert. That's already something. But is it possible to change the standard Worksheet to my own "Template worksheet"? Brgds Sige |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
Thank you guys!
Norman Jones wrote: Hi Sige, Create a single sheet workbook. Set up the sheet to meet your requirements, Save the sheet, selecting Template)*.xlt) from the 'Save as type' dropdown. Save the sheet with a descriptive name. If you want to change the default worksheet, save the template sheet as Sheet.xlt, saving it in the XLStart folder. --- Regards, Norman "Sige" wrote in message oups.com... Hi There, Does a Template SHEET exist? Is it possible to "pre-define" a worksheet? So that when you click: InsertWorksheet you get your Template Worksheet?, instead of the standard Blank. If you right-click your sheet: Insert... you can select a Template to insert. That's already something. But is it possible to change the standard Worksheet to my own "Template worksheet"? Brgds Sige |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
The naming Sheet.xlt plays a crucial role in it I guess?
Creating a new standard workboook... follows a similar pattern? But what name does it need? Workbook.xlt? Cheers Sige Sige wrote: Thank you guys! Norman Jones wrote: Hi Sige, Create a single sheet workbook. Set up the sheet to meet your requirements, Save the sheet, selecting Template)*.xlt) from the 'Save as type' dropdown. Save the sheet with a descriptive name. If you want to change the default worksheet, save the template sheet as Sheet.xlt, saving it in the XLStart folder. --- Regards, Norman "Sige" wrote in message oups.com... Hi There, Does a Template SHEET exist? Is it possible to "pre-define" a worksheet? So that when you click: InsertWorksheet you get your Template Worksheet?, instead of the standard Blank. If you right-click your sheet: Insert... you can select a Template to insert. That's already something. But is it possible to change the standard Worksheet to my own "Template worksheet"? Brgds Sige |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
Hi Sige,
Creating a new standard workboook... follows a similar pattern? But what name does it need? Workbook.xlt? Almost! Use: Book.xlt --- Regards, Norman "Sige" wrote in message oups.com... The naming Sheet.xlt plays a crucial role in it I guess? Creating a new standard workboook... follows a similar pattern? But what name does it need? Workbook.xlt? Cheers Sige Sige wrote: Thank you guys! Norman Jones wrote: Hi Sige, Create a single sheet workbook. Set up the sheet to meet your requirements, Save the sheet, selecting Template)*.xlt) from the 'Save as type' dropdown. Save the sheet with a descriptive name. If you want to change the default worksheet, save the template sheet as Sheet.xlt, saving it in the XLStart folder. --- Regards, Norman "Sige" wrote in message oups.com... Hi There, Does a Template SHEET exist? Is it possible to "pre-define" a worksheet? So that when you click: InsertWorksheet you get your Template Worksheet?, instead of the standard Blank. If you right-click your sheet: Insert... you can select a Template to insert. That's already something. But is it possible to change the standard Worksheet to my own "Template worksheet"? Brgds Sige |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Template Sheet?
Learning fast ;o)
Sige |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert template in new sheet of pre-existing excel file? | Excel Worksheet Functions | |||
Select and Insert one sheet from a multisheet excel template | Excel Discussion (Misc queries) | |||
Insert Rows in Balance Sheet Template | New Users to Excel | |||
#NAME when I insert a sheet from a template | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |