Add a row below an activebutton, keeping the format without resizing the button

[guippezzini]

Hi. I would like to click at the "+" button and add an entire blank row below the "button", so I can put a new hour with new value for a specific day. It is important to keep the format, fill color, and to not resize the button (when I insert a row manually, the button gets bigger to the cell below). I've searched the internet a lot and didn't find a good macro to do it.
The new row must not have the "+"button, or + sign.
Thanks!

Day	Add	Hour	Value
01	+	08:00	2
02	+	08:00	4
		Sum	6

<tbody>
</tbody>

 

[ask2tsp]

this example code does not uses buttons.
if you select a cell that contains a "+" this little piece of code will insert a blank line below that line.
Right click on the sheetlabel, select View code and paste this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count = 1 And Target.Value = "+" Then
        Rows(Target.Row + 1).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    End If
End Sub

the sum formula: if you use =SUM(INDIRECT("D2:D"&ROW(D3)))
it automatically adapts to the extra line inserted

 

[guippezzini]

Thank you for your answer! I still want to make it work using the button.. If this is not possible I will use your method