Customize default print options in new workbooks

S

Snoopy

Hey
Does anybody know if there is a way to customize the print options that
aplies in new workbooks.
I want my (every) new file to print landscape and scale to fit.

Regards
Snoopy
 
R

Ron de Bruin

Hi Snoopy

You can create a workbook template(save as template, xlt) named Book and save that in your xlstart folder
Every new workbook you add have the options that you add to this workbook.

You can do the same for a sheet, save a one sheet workbook with the name Sheet as xlt
 
Top