Excel Button Growing

Question

I'm working on a workbook in Excel 2010 that someone else created (I don't know which version they were using) with a button in it that invokes a macro. There are a lot of macros defined, so I'm right-clicking on it to find out which one it calls, but the context menu doesn't appear. Instead, when I click off, the button gets larger. I can make this happen as many times in a row as I'd like. There is another button the same worksheet that has the same context menu problem, but instead of growing, the text shrinks each time. There is another button that functions normally when I do this.

Answer 1

Growing buttons in Excel is a fairly common issue, with several theories about why this happens, including the use of multiple monitors or using proportional fonts. I have yet to see a definitive answer about this, but there are several workarounds that may work for you.

1. Delete and re-create the buttons.
2. Programmatically set the height and width of the buttons when the workbook is opened and when a button is clicked.
3. Select the button with another object or two on the sheet and group them.
4. Don't use them at all.

My personal choice is #4. As an alternative to buttons, I either use hyperlinks or shapes with macros assigned to them.