Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Macro | Excel Discussion (Misc queries) | |||
Macro Printing | Excel Programming | |||
Macro for printing | Excel Worksheet Functions | |||
Printing Macro? | Excel Programming | |||
Need help for Printing Macro. | Excel Programming |