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

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


"hstijnen" wrote in message
...
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

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.

"Castell" wrote:

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


"hstijnen" wrote in message
...
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

Open a new workbook.

Delete all sheets but one.

Format as you wish.

FileSave AsFile TypeMS Excel Template.

Name it SHEET and store it in your XLSTART folder.

This will be the default InsertWorksheet


Gord Dibben MS Excel MVP

On Tue, 8 Apr 2008 03:16:01 -0700, hstijnen
wrote:

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