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

Good afternoon frendbrenda1

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=466219

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.

frendabrenda1 wrote:

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

--

Dave Peterson