Sheet one of my workbook has a listing of available command buttons. I am trying to get three of those buttons to format the page setup for different print sizes. I am trying to come up with three generic macros that will work if I have 5, 6, 7, or however many worksheets.
Macro 1: Formats all pages to print 8.5 x 11 and then prints
Macro 2: Formats to 8.5 x 14 and then prints
Macro 3: Formats to 11 x 17 and then prints
Is there a generic way of writing this code so that the same macro can be applied to multiple workbooks and adapt to different sheet quantities?