Easily Changing Print Order

Bob wonders if there is an easy way to switch from normal print order to reverse print order and back again. He understands it can be changed in the Print dialog box, but he is looking for a command he can place on the toolbar, instead.

The easiest way to implement a macro approach would be to create two macros. One is used to set normal print order, and the other is used to set reverse print order:

Sub ForwardPrint()
    Options.PrintReverse = False
End Sub

Sub ReversePrint()
    Options.PrintReverse = True
End Sub

The macros are very, very simple and can be assigned to individual toolbar buttons. If you prefer to implement a solution that uses a single macro (so you only need to use one toolbar button), then the following may work just fine:

Sub SwapPrint()
    With Options
        If .PrintReverse = True Then
            .PrintReverse = False
            MsgBox ("Now printing in normal order")
        Else
            .PrintReverse = True
            MsgBox ("Now printing in reverse order")
        End If
    End With
End Sub

This approach toggles the PrintReverse property, so it switches between normal and reverse order. The macro also displays a dialog box that indicates the current printing order.