Centering text on an ActiveX button

[tobyz95]

I have searched high and low and cannot seem to find an answer. I have inserted an ActiveX button in a cell to run 3 macros when pressed. I cannot get the 4-letter name on the button to appear centered on the button, unless I make the button larger than the cell, which I do not want to do.



Any insight here would be GREATLY APPRECIATED!

 

[starl]

Have you tried making the font smaller? How small is the cell? What is your font setting?

 

[tobyz95]

Have you tried making the font smaller? How small is the cell? What is your font setting?

Hello, Thanks for responding. The cell Height is 15.00(20 pixels) Width is 5.86(46 pixels)
I went down to size 6, but it still was not centered, and frankly was also too small.

I ended up changing it to a Form button instead, and made a macro to run the 3 macros' I wanted.
That one can be formatted, where the ActiveX button can not be altered as much or not enough in my case. <img src="http://www.orangemane.com/BB/images/smilies/shrug.gif" abp="1">

 

[starl]

That is *really* small..

ActiveX can be formatted, but there are limitations.

It is interesting that the form control has smaller margins. Your other option would have been to use an ActiveX label - they can be formatted to look like buttons and have smaller margins. But the text sits along the bottom of the frame

 

[tobyz95]

That is *really* small..

ActiveX can be formatted, but there are limitations.

It is interesting that the form control has smaller margins. Your other option would have been to use an ActiveX label - they can be formatted to look like buttons and have smaller margins. But the text sits along the bottom of the frame

<img style="width: 60px; cursor: pointer;" alt="" src="http://www.alispagnola.com/Free/horse3.jpg" border="0" /> Hi again, I also find it interesting. It seems like the programming is incomplete, or wasn't even addressed to begin with. Thanks for the info on ActiveX label...I have not used that feature as of yet, and will explore more.

Thanks again for your time and expertise!