Macro for Multiple Print Options

[jaredmccullough]

I am looking to design a Userform with either "OptionButtons" or a ComboBox in which the user selects 1 of 4 print formats. The following are the 4 Print Formats:

Print1:
.2 Margins (Top/Bottom/Sides)
Fit all Columns To Page
Rows 1-17 are Normal
From row18 on every row with text in columnA becomes a print break with row16 as a header before it. (the point of this is that row16 is a header but since it will always on the first page and row17 is a text row that would kick it on the next page)

Print2:
.2 Margins (Top/Bottom/Sides)
Fit all Columns To Page
Cells A1:F15 select fit to page and center (This will be the 1st page)
Row16 becomes header for the rest of the sheets. Then each row with text in columnA becomes a print break

Print3:
.2 Margins (Top/Bottom/Sides)
Fit all Columns To Page
Cells A1:F15 select fit to page and center (This will be the 1st page)
Row16 becomes header for the rest of the sheets. Then each row with text in columnA becomes a print break. Hide ColumnE and ColumnF after row15.

Print4:
.2 Margins (Top/Bottom/Sides)
Fit all Columns To Page
Cells A1:F15 select fit to page and center (This will be the 1st page)
Row16 becomes header for the rest of the sheets. Then each row with text in columnA becomes a print break. Hide Column A, B, E, F after row15.

[Muzza86]

Just create a button.

then right click on it to assign a macro.
name it
record....

then go into print settings and set up the PRINT1 settings and press print.

go to "view" tab and macro and stop macro.

then when they click on that button it will print a doc to the settings u chose..

repeat for next print button with different settings.

[jaredmccullough]

Muzza the reason I was wanting to use a userform was for formatting issues as the WS has quite a "buttons" on it already. I was going to have one single button that stimulates the userform mentioned above which allows the user to pick from 4 options. Then there will be a commandbutton1 on userform which allows them to "Print Preview" the selected print style and a commandbutton2 on the userform which allows them to "Print" with the chosen style.