Printing Option Buttons

[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?

 

[Gord Dibben]

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

 

[terri]

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.

 

[Gord Dibben]

What do have the BackColor set to?

Is there a problem with that?

Maybe set it to a more neutral color.


Gord

 

[terri]

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.

 

[Gord Dibben]

I'm out of ideas.

Gord

 

[terri]

Oh well... thanks for trying.
--
terri

I'm out of ideas.

Gord



.