Insert Template Sheet?

[Sige]

Hi There,

Does a Template SHEET exist?

Is it possible to "pre-define" a worksheet?
So that when you click:
Insert>Worksheet> 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

 

[Tom Ogilvy]

create a workbook with your single sheet template and name it Sheet.xlt and
place it in your xlstart directory.

 

[Norman Jones]

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.

 

[Sige]

Thank you guys!

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.

 

[Sige]

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

 

[Norman Jones]

Hi Sige,

Creating a new standard workboook... follows a similar pattern?
But what name does it need? Workbook.xlt?

Almost! Use: Book.xlt

 

[Sige]

Learning fast ;o)

Sige