Excel 2007 printing defaults

How can I set default print settings in Excel 2007 to always print with the "scale to fit" setting?
LVL 1
hindsightAsked:
Who is Participating?
 
ScriptAddictConnect With a Mentor Commented:
Only thing that I can think of off hand is to add some vba that captures when you create a new worksheet and automatically sets it to scale to a single sheet.

I would store this on my personal worksheet(this opens hidden every time you open Excel, so it would always be working)

My understanding of the way Excel works is that these values are null until specifically assigned.

Here is the vba to assign a worksheet to print to a single page.


With ActiveSheet.PageSetup 
    .TopMargin = Application.InchesToPoints(0.2) 
    .BottomMargin = Application.InchesToPoints(0.5) 
    .LeftMargin = Application.InchesToPoints(0.17) 
    .RightMargin = Application.InchesToPoints(0.18) 
    .HeaderMargin = Application.InchesToPoints(0) 
    .FooterMargin = Application.InchesToPoints(0) 
    .Orientation = xlPortrait 
    .CenterVertically = False 
    .FitToPagesWide = 1 
    .FitToPagesTall = 1 
End With 
 
End Sub 

Open in new window

0
 
ScriptAddictConnect With a Mentor Commented:
Opps,

Looks like we might need a

.Zoom = False 

Open in new window

in there as well.
0
 
ScriptAddictConnect With a Mentor Commented:
I suppose you could just:
Open a new workbook. Customize as you wish. File>Save
As Type: *.XLTX

"BOOK"

Excel will add the .XLTX to save as BOOK.XLTX
Save this workbook in the XLSTART folder
C:\Documents and Settings\ProfileName\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLTX in XLSTART folder also. It now becomes
the default Insert>Sheet.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.