Changing Default Margins in Excel 1

[wesmk]

Wanting to change the default margins in various versions of Excel. Does anyone have any suggestions or do you just have to change the default each time? Thanks for any help

Wesmk

 

[GrayShades]

If nothing else, use this macro (adjust margins accordingly) in Personal.xls file, then assign it to a button and put it on a toolbar.

Sub Margins()
    With ActiveSheet.PageSetup
        .LeftMargin = Application.InchesToPoints(0.5)
        .RightMargin = Application.InchesToPoints(0.5)
        .TopMargin = Application.InchesToPoints(0.5)
        .BottomMargin = Application.InchesToPoints(0.5)
        .HeaderMargin = Application.InchesToPoints(0.25)
        .FooterMargin = Application.InchesToPoints(0.25)
    End With
End Sub

Software: XL2002 on Win2K
Humanware: Older than dirt

 

[wesmk]

Kinda new at this, could you maybe help me step by step on creating this macro?

 

[macropod]

To set Up Excel’s default workbooks and worksheets, create a workbook with all the settings you like. Save it as:
1. an Excel template named Book.xlt, and also
2. as a template named Sheet.xlt.
Store both in your XLSTART folder, typically:
C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
but check also under Tools|Options|General.
Note: Application Data is a hidden folder, so you must display hidden files and folders in order to see it.

Book.xlt will be used as the standard new workbook.
Sheet.xlt will be used as the standard new worksheet (Insert |Worksheet).

You would normally save Sheet.xlt as a workbook that contains just one worksheet. Otherwise, inserting a worksheet will result in multiple sheets being added.

Cheers