I am doing up a Print Macro for a worksheet.
I would like it to be dynamic such that I could select for certain Tabs in the workbook to be printed as Zoom or Fit to Pages
I have no problem with Zoom but I do have problem writing the codes for FitToPagesWide.
I know these two are mutually exclusive so I have a .Zoom = False before my FitToPagesWide code.
I have looked up the forum a lot of examples provided are
FitToPagesWide = 1
My question is, what if I do not want it to be 1 but 10? And this 10 is to be dynamic i.e. an "input" in Cell E10 in my worksheet "Print Macro"
Also some Tabs I would want to print in A4 and some in A3. How do I make this to be dynamic i.e. an "input" in Cell D10in my worksheet "Print Macro"
Many thanks!
I would like it to be dynamic such that I could select for certain Tabs in the workbook to be printed as Zoom or Fit to Pages
I have no problem with Zoom but I do have problem writing the codes for FitToPagesWide.
I know these two are mutually exclusive so I have a .Zoom = False before my FitToPagesWide code.
I have looked up the forum a lot of examples provided are
FitToPagesWide = 1
My question is, what if I do not want it to be 1 but 10? And this 10 is to be dynamic i.e. an "input" in Cell E10 in my worksheet "Print Macro"
Also some Tabs I would want to print in A4 and some in A3. How do I make this to be dynamic i.e. an "input" in Cell D10in my worksheet "Print Macro"
Many thanks!