I used a form control to add some buttons to my worksheet. The buttons have
been set to transparent because I cannot align the text to the upper left
corner and the small size of the buttons will cut off a portion of the text.
My problem is that when I click on the transparent button, the back color
shows up, hiding the text behind the button and will not go away until I
click on another cell that does not have a button. I need the button to stay
transparent so the user can see the text behind the button at all times.
What am I doing wrong?

AFAIK, nothing wrong, that's how it works. You also set
TakeFocusOnClick=False, but the button will not be transparent, whilst it's
being clicked.
You can assign a macro to a Shape instead, if that is suitable.

NickHK

"LaNae" <(E-Mail Removed)> wrote in message
news:AA251FBB-73E2-42C6-8142-(E-Mail Removed)...
> I used a form control to add some buttons to my worksheet. The buttons
have
> been set to transparent because I cannot align the text to the upper left
> corner and the small size of the buttons will cut off a portion of the
text.
> My problem is that when I click on the transparent button, the back color
> shows up, hiding the text behind the button and will not go away until I
> click on another cell that does not have a button. I need the button to
stay
> transparent so the user can see the text behind the button at all times.
> What am I doing wrong?

It's fine that the button color shows while it's being clicked, I can live
with that. But is it supposed to stay highlighted? Can I get the button to
go back to being transparent after I have clicked on it? I have tried setting
the focus property to false but still no results.

Thanks so much for replying. I am new to this aspect of Excel and this is
driving me crazy.

"NickHK" wrote:

> AFAIK, nothing wrong, that's how it works. You also set
> TakeFocusOnClick=False, but the button will not be transparent, whilst it's
> being clicked.
> You can assign a macro to a Shape instead, if that is suitable.
>
> NickHK
>
> "LaNae" <(E-Mail Removed)> wrote in message
> news:AA251FBB-73E2-42C6-8142-(E-Mail Removed)...
> > I used a form control to add some buttons to my worksheet. The buttons
> have
> > been set to transparent because I cannot align the text to the upper left
> > corner and the small size of the buttons will cut off a portion of the
> text.
> > My problem is that when I click on the transparent button, the back color
> > shows up, hiding the text behind the button and will not go away until I
> > click on another cell that does not have a button. I need the button to
> stay
> > transparent so the user can see the text behind the button at all times.
> > What am I doing wrong?
>
>
>

Which version of Excel:
2002:
TakeFocusOnClick is the best you do.
2000:
TakeFocusOnClick has no effect. You lose transparency as soon as the button
is clicked.

Use a Shape and assign a macro then.

NickHK

"LaNae" <(E-Mail Removed)> wrote in message
news9368CAA-A5BA-43E1-A534-(E-Mail Removed)...
> It's fine that the button color shows while it's being clicked, I can live
> with that. But is it supposed to stay highlighted? Can I get the button
to
> go back to being transparent after I have clicked on it? I have tried
setting
> the focus property to false but still no results.
>
> Thanks so much for replying. I am new to this aspect of Excel and this is
> driving me crazy.
>
> "NickHK" wrote:
>
> > AFAIK, nothing wrong, that's how it works. You also set
> > TakeFocusOnClick=False, but the button will not be transparent, whilst
it's
> > being clicked.
> > You can assign a macro to a Shape instead, if that is suitable.
> >
> > NickHK
> >
> > "LaNae" <(E-Mail Removed)> wrote in message
> > news:AA251FBB-73E2-42C6-8142-(E-Mail Removed)...
> > > I used a form control to add some buttons to my worksheet. The
buttons
> > have
> > > been set to transparent because I cannot align the text to the upper
left
> > > corner and the small size of the buttons will cut off a portion of the
> > text.
> > > My problem is that when I click on the transparent button, the back
color
> > > shows up, hiding the text behind the button and will not go away until
I
> > > click on another cell that does not have a button. I need the button
to
> > stay
> > > transparent so the user can see the text behind the button at all
times.
> > > What am I doing wrong?
> >
> >
> >