On Jan 9, 2:36 pm, "Peter T" <peter_t@discussions wrote:
Unfortunately, although you can apply Transparent it does not persit when
the control is clicked, it will then show whatever colour is set for its
backcolor property. I don't know if this has been fixed in XL2007

Regards,
Peter T

"AJ Master" wrote in message

...

I have placed several checkboxes on my spreadsheet and under
properties for the checkbox I have selected the backstyle =
fmBackStyleTransparent. My problem seems to be that whenever I click
on the checkbox the background color changes from the color of the
cell to white. On the properties window the BackColor is set to white
so I'm guessing this is the problem. Does anyone know how to change
the back color to transparent as well? I cannot select the cell color
because it does not appear as a choice on the palette when I try to
change it to that?

Any help would be appreciated.

AJ

Peter,

Is there anyone to code an event change that would update the
backcolor? Is there a way to add the custom color I'm using to the
color palette excel shows me?

Thanks again...AJ