How to change a checkbox if checked to an asterisk when printing in excel?

[Excellman]

Is it possible to change a checkbox, if checked, to an asterisk only during printing in excel?
But if the checkbox is not checked then it would print normally as an empty checkbox.

 

[Anthony47]

Fill the cell that is normally hidden by the checkbox with the asterix.

Then locate "ThisWorkbook vba Module" and load there the following macro:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Sheets("Foglio1").CheckBox1    '<<< The Sheet and the Control name
    If .Value = True Then
        .PrintObject = False
    Else
        .PrintObject = True
    End If
End With
End Sub

The line marked <<< need to be customized with the sheet name and the correct control name; by the way, I assumed that you are using an ActiveX checkbox (not a "Modules" one).

The macro will change the control's print property to True (if the checkbox is empty) or False (if the checkbox is checked)

Bye

 

[Excellman]

Hmmm... this Macro Module didn't work. It had no affect on the checkboxes. I'm not sure what you meant by "Fill the cell that is normally hidden by the checkbox with the asterix." I will post an image to help clarify what I'm looking to do... The first image is of the checkboxes with two of them checked and the others not checked. The checked ones would be replaced by an asterisks and the unchecked ones will just go away and not be printed, as in the 2nd image. Also, what should the settings be for each checkbox under 'format control' ---> Properties ---> Print Object; checked or unchecked? <--- This has an affect on whether the checkbox is printed or not and I don't know if the VBA code overrides this setting or not. Thanks for your input.

 

[Anthony47]

By "Fill the cell that is normally hidden by the checkbox with the asterix." I mean the following:
-if you insert a checkbox in say position B1 then the cell will be hidden by the checkbox
-if you write an * in that hidden position, then the * will be unvisible if the checkbox is not checked and the macro will set its property to Print-the-Object to True; if hovever the checkbox is checked than the macro will hide in the printout the checkbox so that the * get visible on the print

But now you ask that anyway the checkbox be not printed, so that macro will not do the job, we have to set or remove the * in the cell behind the chcckbox

Also you have many checkboxes, and all of them should be manipulated, and that requires further coding.
However the image leaves too many unclear situations, if you publish a sample of your workbook maybe we shall be able to come with an applicable solution.

Bye