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.

 

[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