• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Print Macro for Selected Sheets from 200+ Worksheets


New Member
Also when editing the print specs for each sheet (after double click), maybe you can use drop down boxes for Page Size, Orientation, No of Copies etc.


Excel Ninja
Staff member

I appreciate your interest and suggestions in this but it is provided free to all as is, where is.

No warranty or support provided

If others want to add to it as long as they make it available here I am happy

I will get to your suggestions at some stage
Hi Hui,
I have lot of customer invoices in excel wb for printing, i want to done it through selecting list just like this post, i need

Have a try of this version


It has:
  • A selection of Page No layouts
  • Multiple Copies
  • Multiple Copies of each page
  • Editable page characteristics (Size & Orientation )
I haven't checked that it is working 100% so any feedback appreciated
Hi Hui,

I have problem just like this post, i try to download this file but is disable. will you please send me this file or upload again with correct path.
Here is the file:
Thanks for uploading file. I need little bit change, if possible that code allow me to browse another workbook sheet for select & print. Also when start printing code make pause for 20 second after every 10 pages print.
Is it make sense.


New Member