"Don't Move or Size with Cells" not working

johnf

New member
Joined
Dec 12, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2010
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.
 
Back
Top