Command Button & Font Size

[JJ]

I've a spreadsheet with a command button (macro to sort spreadsheet).
Command button works great but the text on the command button keeps reducing
in font size over time for no apparent reason. Properties of command button
still says font of 36, however in reality it appeats to be about 6 or 8.

I stuggled to change it back to proper size once before, however I don't
have time to fight with it today.

Can anyone advise how to change font size and how to stop this from happening.

Thanks,

JJ

 

[ryguy7272]

I don't think I've seen this behavior before, but I'll hazard a guess:
Right-click on the button > Format Control > Properties > Don't move or size
with cells > OK.

Good luck,
Ryan---

 

[JJ]

It is already set as you recommended. As well, the command button properties
are
Caption - 'Sort Client List' (this is what is changing)
Font - Arial 36 (now about 4)
Locked - True
I believe the font size reduction occurs when I click the command button
(not positive if it occurs every time or just occasionally).

Guess I should have noted I'm using Excel 2003.

 

[ryguy7272]

Let’s try to straighten this out without a writing campaign, back and forth,
back and forth. All I can think of, and I’ve never had see this personally,
is that you need to replace the CommandButton (Active X) from the control
toolbox toolbar with a button from the Forms toolbar (Form control). I’m
assuming that you are using a Private Sub, right. I’m at school now, and
they use Excel 2007 here. I still haven’t figured out how to do these things
in 2007, but you are working in 2003 anyway. If the code is under the Sheet,
just move it to a module and run it from there.

Or, if you want to stick with that Private Sub, delete that CommandButton
and replace it with another CommandButton and relink it to your code (from
the same control toolbox toolbar). Maybe the Button go corrupt or some such
thing. Excel is very reliable, but every once in a while it does things that
are weird and inexplicable.

Good luck,
Ryan---

PS, you can see this tutorial:
http://www.mrexcel.com/tip068.shtml

This may be helpful too:
http://office.microsoft.com/en-us/excel/HP102366761033.aspx

 

[JJ]

Thank you very much Ryan! I tried all ways you suggested (mainly for leaning
purposes) and they all worked! I eventually settled on using command button
from the forms tool bar and deleting the existing one. In the meantime I
learned 2 other ways for creating such an object

MrExcel.com is also very helpful and I have added to my favorites.

Thanks!
JJ