I have an excel sheet that many people in my company use for estimates. Users add rows and header with macro buttons. I am trying to create a button that finds how long the estimate is, selects the range of the estimate that would require printing, and then open up the backstage print page. I want to print from the backstage view because there are many different ways in which the user will print (to printer, to pdf, 8x11, 11x17, etc) and I want them to be familiar with the view.

I am wanting to have the backstage print view automatically select Landscape, fit columns and print selection. I can not figure out a way for these 3 options to be automatically selected. Does anyone know if there is a way or a work around.

The code I have working this for grabs the selection and opens the backstage print view.

Please Login or Register  to view this content.