Print Specific Tabs, using Check Boxes

[tbcii]

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]

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

 

[tbcii]

I'll give it a shot