Default Print Layout

[hstijnen]

Hi,

I've created a Map.xlt with a defined layout for printing. Now every new
workbook I open has this print layout.
However, when I insert a new worksheet in my workbook, this sheet doesn't
have that predefined layout.
Does anyone know how to realize that?

thanks,
Henk

 

[Castell]

Right click on sheet, select Insert, select your Map.xlt file instead of the
default Worksheet template Excel uses.

 

[hstijnen]

Then I get the whole workbook inserted. In my case there ara several sheets.
I only want one sheet inserted.
For the time being I've written some VBA to do it.

 

[Gord Dibben]

Open a new workbook.

Delete all sheets but one.

Format as you wish.

File>Save As>File Type>MS Excel Template.

Name it SHEET and store it in your XLSTART folder.

This will be the default Insert>Worksheet


Gord Dibben MS Excel MVP