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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing name of custom by using formula or view - footer/header-options 3
Printing both landscape and portrait in same print option 5
Epson XP-3150 not printing 2
Macro executing (copy data) from at sett of sheets in the workbook 3
Printing options for all sheets in a workbook? 3
Macro that "shows all data " in several sheets. 1
Excel 2007 print option gone 1
printing frozen column on each page 2

Back
Top