• 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

    Hui...

  • 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

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.
 
Jkwee


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
Jkwee


Have a try of this version

https://www.dropbox.com/s/5dkjb81zg41wg4i/Print_Using_ListBox5.xlsm


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.
 
Back
Top