T tbcii New Member Sep 23, 2009 #1 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.
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.
K keymaster New Member Sep 23, 2009 #2 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
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