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

Creating a Print worksheet Button

Dennis W

New Member
I working on a "Mother Page" for a Production sheet.
there is a 3 week cycle for production. each day has potentially between 0 - 11 separate Worksheets. so that means 241 potential Worksheets
What I want is to insert a "Button" on the Main page that allows me to print a specified Worksheet. or ideally, a command all button that allows me to automatically print all worksheets (Production Sheets) which have a value greater than 0. Can someone help me.
 
You can use a (multiselect) listbox to select sheets to print
See example
 

Attachments

  • Print sheets.xlsm
    36.4 KB · Views: 5
Back
Top