Print Multiple Worksheet Print Macro

Good morning,
I'm sure it's possible, but the code is beyond my technical expertise, to program a form control button to open up the print dialogue and execute the printing of multiple worksheets in my workbook. I intend to have this button on a sheet that does not print (Sheet 1). I would like the other sheets to print with one click of the mouse, so to speak. How do I tell Excel to do this? How do I list the sheets I want to print in the macro (so I can change this button if I add or change the names of worksheets)?
Thank you.

Well, I programmed a macro to do this using record macro and clicking around a lot. It worked, but now the page numbers on the first worksheet change from 1 of 2 and 2 of 2 (a printed on two sides document) to 1 of 7 and 2 of 7. How can I prevent this from occurring?
Thanks!

Solved: I figured it out. Maybe this will help someone else.

---

Please Login or Register  to view this content.