print checkbox

F

frendabrenda1

I have a spreadsheet with several checkboxes, and a macro that automatically
prints the page when the user chooses. Sometimes the checked boxes will
print with a check, and other times even though the box is checked on the
screen, a check does not appear on the print. I would like the checked boxes
to print as checked all of the time. Any ideas??? Thanks so much
 
D

dominicb

Good afternoon frendbrenda1

It depends exactly what you have used to set up the checkboxes.
suspect you have probably used the Forms toolbar. If you select
checkbox, right click and select format control, properties, there is
tick box marked Print Object. Just make sure that this is ticked fo
each object you want to print.

HTH

Dominic
 
D

Dave Peterson

And I was gonna guess you used the checkboxes from the control toolbox toolbar.

I was going to suggest that you try the checkboxes from the Forms toolbar to see
if they behave better.
 
Top