Insert Row Button Macro

[bpgolferguy]

Is it possible to create a button in excel with a macro that states when the button is clicked, a new row (formatted the same...borders, font, etc) is created in a spot in the document? Basically I'm creating a worksheet for a department that could have 1 or 50 entries based on the day, so I want them to have the ability to add however many rows they need to. Is that possible? If so, what would it look like?

 

[VoG]

Try assigning this macro to a button

Sub InsRow()
With ActiveCell.EntireRow
    .Insert
    .Copy
End With
Range("A" & ActiveCell.Row).PasteSpecial Paste:=xlPasteFormats
Application.CutCopyMode = False
End Sub