Don't move or size with cells not working!

[johnfgenesis]

I have added a column of buttons to a worksheet (in a dashboard format) each of which has a macro assigned to it. Each macro adds a row to a certain section of the worksheet form, so that each time a button is clicked, a new row is added. Each button's properties are set to "Don't Move or Size with Cells", but sometimes the buttons vertically expand or contract, apparently on their own with no obvious pattern. My guess is that this is a bug in Excel (?) Any suggestions on how to prevent this from happening? One other forum I checked suggested creating the buttons with a macro (or setting the properties of the buttons with a macro) every time the worksheet is opened. Thank you for your help.

[shg]

If these are ActiveX controls (vs from the Forms toolabr), they are indeed buggy.

How about using Forms buttons or autoshapes?

[johnfgenesis]

Hi. Thanks for replying. The buttons are shapes from the excel shape library, with macros assigned to them. I didn't use ActiveX controls. I've attached a screen shot to demonstrate how one of the buttons has expanded vertically.

Attachment 653745

[shg]

I can't open your attachment. Post a workbook that illustrates.