Printing Option Buttons

  • Thread starter Thread starter terri
  • Start date Start date
T

terri

I am using options buttons inserted from the Control Toolbar (Excel 2003).
They function correctly and appear fine in the worksheet. When printed, the
button graphic always is displayed in a black square. I have tried changing
the backstyle and backcolor properties to no avail.

What am I missing?
 
If you don't want the button printed, in Properties uncheck "Orint Object"

If you do want it printed, fiddle about with printer settings for color and
black and white.


Gord Dibben MS Excel MVP
 
Thanks for your response.

I do need the option buttons to print.

When I print to a color-capable printer, the button looks fine in either B&W
or color. When I use a non-color printer, the button (but not text) has a
black background. The same is true if I print to a pdf (the B&W/Color
options make no difference).

It always previews fine, with any printer selection.
 
What do have the BackColor set to?

Is there a problem with that?

Maybe set it to a more neutral color.


Gord
 
I originally had the BackStyle set to Transparent with the BackColor set to
Window Background (which is white). I tried switching to Opaque and setting
the BackColor specifically to White -- no difference.
 
Back
Top