only checked boxes print

Question

I am attempting to create a checklist however I only want the checked items to print out. How can I do this?

Answer 1

Can you upload a sample workbook with at least one sheet showing examples of how you have things set up?  We need to know whether these are checkboxes from the Forms group or if they are ActiveX checkboxes and even whether they are on a worksheet or if they are on a UserForm.

Basically you're going to need VBA code (a macro) associated with the Workbook_BeforePrint() routine to examine those checkboxes and somehow make them visible/invisible based on their checked status.  Exactly how that is to be done is in question - and with this kind of thing, there's the problem of making them ALL visible again after the printout is done because even in code we cannot determine when the printout process has finished.  But as long as we'd be adding code to the workbook anyhow, we could add a process to make them all visible again at the click of a (not printed ever) button on the sheet.