Hi,

I have a Command Button starting a macro. Every time I click on the button
the text gets smaller, until invisible. I've changed the macro it runs, but
still get the same behaviour. The button remains the same, it's just the text
that gets smaller. If I go into design mode and change the size of the box
the text returns. I've also selected 'Don't move or size with cells' - still
got the problem. Any ideas?

You know, I was JUST ABOUT to post the exact same thing! Except in my case,
the text get larger! Go figure...

"Andy" wrote:

Hi,

I have a Command Button starting a macro. Every time I click on the button
the text gets smaller, until invisible. I've changed the macro it runs, but
still get the same behaviour. The button remains the same, it's just the text
that gets smaller. If I go into design mode and change the size of the box
the text returns. I've also selected 'Don't move or size with cells' - still
got the problem. Any ideas?

I've not experienced this myself, but you could try either/or setting the get
focus on click property to false specifying the font size as part of the
click event. I successfully used the latter to retain the dimensions of a
listbox on a worksheet.

"Matt S" wrote:

You know, I was JUST ABOUT to post the exact same thing! Except in my case,
the text get larger! Go figure...

"Andy" wrote:

Hi,

I have a Command Button starting a macro. Every time I click on the button
the text gets smaller, until invisible. I've changed the macro it runs, but
still get the same behaviour. The button remains the same, it's just the text
that gets smaller. If I go into design mode and change the size of the box
the text returns. I've also selected 'Don't move or size with cells' - still
got the problem. Any ideas?