Check Box In Excel 2002

[BellKev]

Good Afternoon Folks ...

I have a "Check Box" control in Excel 2002. Is there a way I can change the check mark to an "X" ... or maybe somehow cause the fact that the box is checked become more apparent? I only ask because I have had people complain that the check mark is hard to see when a document is printed (It's small and not very heavy) ...

 

[CautionMP]

BellKev,
No, not that I could find. Here is another approach. When you format the control tie it's value to a cell on the worksheet and set the Print Object property to false. This will give you a cell that prints True/False and not the checkbox when sent to the printer.

If you were to move the linked cell outside of the print area you could then use a If() statement to display an 'X' in the cell if the checkbox is True. A final polishing touch might be to add conditional formatting so that when the checkbox is true the cell is encased in a border (for print purposes).

Hope this helps.