Excel 2010 Command Buttons Grew Smaller Then Font Within Grows Larger

[PWD]

Good morning. I've never seen this before. I have a workbook (.xls in Compatibilty mode) that has been running code since - forever. The last time I ran it I think I must have hit some weird key/mouse combination because each time I clicked on my command button it shrank in size. I resized the button but today, each time I click on it the font appears larger. The only absolute that I think I've established is that this happens every time the button is clicked - including right clicking. Has anyone seen this before - and, hopefully got a solution?

Many thanks,
D€$

 

[PWD]

So it's known, but no solution suggested.

thread68-1616646


Many thanks,
D€$

 

[PWD]

Teeny, tiny tinkly bell at the back of my cranium when I found this link posted:-

http://support.microsoft.com/kb/838006

This along with resetting the Autosize property to True seems to have fixed it for me.

Somebody else wrote:-

Tried EVERYTHING listed above (and more!) - nothing worked...

UNTIL NOW!

I just found the solution on another site and wanted to share it here. I take NO credit for this! If it works for you - then AWESOME - but don't thank me... I'm just passing it along.

OK - here ya go:

i) In design view, select all the controls in the sheet.

ii) Right click and select Grouping ->Group to group the controls

Then save the workbook.

By golly THAT did the trick for me!

Many thanks,
D€$