Making "Selection" the default in print dialog box?

**pradhan** · 05-27-2010, 01:23 PM

19 out of 20 times, when I print from Excel, I choose to print the "selection" as opposed to the worksheet. Is there any way to make that the default setting?

Thanks
Pradhan

**Palmetto** · 05-27-2010, 05:29 PM

I may be in error but, as far as I know, you cannot set this. You will have to use a macro to set the print area to the selection.

Something along the lines of:

Option Explicit

Sub Print_Selection()

    With ActiveSheet
        .PageSetup.PrintArea = ""
        .PageSetup.PrintArea = Selection.Address
    End With

End Sub