Question Locked

How do I set print dialog print range to default to Pages From:1 To:1?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

All day long I print Excel 2007 spreadsheets that have hundreds of pages.

I always only need to print the first page of these spreadsheets.

Each time I print, I need to change the "Print range" in the print dialog from "All" to only print from page 1 to page 1.

Is there a way I can set "from page 1 to page 1" as the default? Making changes to the registry would be acceptable. OS is XP SP3.

2 replies

by robo_dev

http://forums.devx.com/archive/index.php/t-78786.html

http://www.mrexcel.com/forum/showthread.php?t=80208

http://www.ozgrid.com/VBA/vba-macros.htm

Sub PrintPages()
Dim f, t As Integer

f = InputBox("Select start page 1 to 10", "Print From")
t = InputBox("Select end page " & f & " to 10", "Print To")

If MsgBox("Do you wish to print pages " & f & " to " & t, vbYesNo, "Confirm print") = vbYes Then
ThisWorkbook.PrintOut f, t
Else
End If

End Sub

This discussion is closed to new replies.