Hi everyone,
I've tried searching on this issue -- to no avail.

I have a multi-sheet workbook with VBA functionality embedded in Command Buttons (CommandButton Objects from the VBA Toolbar). Each of these buttons has a different function and a different caption. Each one has the caption's font properties set to Arial, 9, Regular Style (no bold, etc).

When the button is used to trigger its functionality, everything works, but the caption becomes distorted. Generally it appears as though the font changes size, and becomes bold, for example, the button captioned "Discount" will now show the top left of a large "D" and "i" but nothing more. The button size doesn't change, and if the font properties are viewed, they have not changed either. I've tried "Locking" the buttons, that didn't appear to help, nor did binding them to the cells they're in.

The only "fix" I've found for this is to manually re-size the button itself, which seems to reset the caption back to normal. Obviously this isn't an acceptable fix. Can anyone suggest a way to prevent this from happening?

Thanks in advance,

Rich