Default Print Layout

H

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
 
C

Castell

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

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.
 
G

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
 
Top