Prevent Button from shrinking and being deleted with row

Right click on the Button, format control, properties and select "Don't move or size with cells."
Or hold down your Ctrl key while left clicking on your Button (to select it) and then run this code.

Sub No_Shrink_Button()
    With ActiveSheet.Shapes
    With Selection
        .Placement = xlFreeFloating
        .PrintObject = False
    End With
    End With
End Sub