Customize default print options in new workbooks

  • Thread starter Thread starter Snoopy
  • Start date Start date
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
 
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
 
Back
Top