Printing Macro
I need your assistance. I currently use a macro based on my drop down
selection provided. I would like to know if there is a way that I can print
a page for each of the selected drop down using a macro. In other words,
print all with one click.
Here is my code that I use. This code is used after I make my
drop down selection.
Hope this helps you.
Private Sub CommandButton12_Click()
Range("A:HB").EntireColumn.Hidden = False
For Each c In Range("C1:HI1")
If c < 1 Then Columns(c.Column).Hidden = True
Next c
Range("B10").Select
End Sub
|