Remove padding from ActiveX button

[excelisland]

Hi, please see attached image. I have an ActiveX button and I need it to be pretty narrow. Is there a way to remove the padding on top and bottom of the text so I can make the button narrower?

Thanks

Button.JPG

[Logit]

Right click the button.

Use the dots to adjust the size.

[excelisland]

It's not a resizing issue. Look at the image attached. They are both the same size with the same text but the bottom one is a form button and the top one is an ActiveX. The form one doesn't have padding around the text, and you can see the text. But, the ActiveX one does and you cannot see the text. Is there a way to remove that padding so I can see the text?

Attachment 703557

[Logit]

.
I can't view your second attachments. I suspect you did not use the GO ADVANCED ?

I recall from experience the ActiveX button can be resized in such a manner as to cover the bottom of the text. So re-sizing would be the method of correction.

If you can repost your last images, that would help.

[excelisland]

Did it work now?

Button.JPG

[Logit]

.
I see the images now.

The top (green) is the Active X ? Does it contain the same term "Templates" ?

Is there a FONT SIZE difference between the two buttons ?

[Rick Rothstein]

.
I see the images now.

The top (green) is the Active X ? Does it contain the same term "Templates" ?

Is there a FONT SIZE difference between the two buttons ?

To add to Logit's questions... is there perhaps a Line Feed character at the beginning of your text?

[Logit]

Here is a sample of the two buttons here. The two BOTTOM BUTTONS are ActiveX :

[Logit]

.
What does your ActiveX button look like if you resize it so the CAPTION is showing ?

[excelisland]

Both buttons are the same font size. There is not anything before the text. When I size it to the size of the Form button, the text disappears.

[zzzeddy]

Hi

Is there a particular reason why do you want to use an ActiveX button on the worksheet, rather than a Form button???

zeddy

[excelisland]

I want to use an ActiveX button because it allows me to change the color of the button. Upon research, I have found you cannot change the color of a form button.

[romperstomper]

Do you really need a button specifically? Couldn't you assign the macro to a shape - you can format those in a huge number of ways; or use the Ribbon? ActiveX controls on worksheets are best avoided unless absolutely necessary.

[excelisland]

I just need a rectangle I can click that will run a macro. Doesn't have to be a button.

[excelisland]

I think I figured it out. Thanks for the suggestion Rorya!

[zzzeddy]

Just insert a shape.
You can use one that looks like a gold bullion bar.
Or just a simple rectangle. And make it any colour you like.
Easy to add text to the shape.
98.6% of experts would avoid using activeX objects on a worksheet if they could use something else instead.

zeddy
P.S. I made that statistic up.

[Logit]

.

P.S. I made that statistic up.

Probably a close guess. ActiveX button can cause errors that are impossible to fix. Just like MERGED cells.

[excelisland]

Noted - will not use ActiveX buttons in the future. I ended up using a colored rectangle and assigning the macro to it. Thanks again for all the help everyone!

[Logit]

.
Glad you have an answer !