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" <(E-Mail Removed)> wrote in message
news:4CA52FA8-5FC2-4357-94D0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:4CA52FA8-5FC2-4357-94D0-(E-Mail Removed)...
> > 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.

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

On Tue, 8 Apr 2008 03:16:01 -0700, hstijnen <(E-Mail Removed)>
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