• 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 Specific Tabs, using Check Boxes

tbcii

New Member
How do I set up a list of Check boxes, with tab names, and then print only the tabs that have been checked?

Have a file to use as an example.
 

keymaster

New Member
You can do this with Macros ofcourse. Insert the checkboxes and link them to one each cell. Name the cells as a range like "printList"


Now, also insert a button and call it "print" or something. Assign the macro to it. In the macro write code that would,


loop through printList,

for each true, print the corresponding worksheet (activeworkbook.sheets)


Good luck
 
Top