Add an Active-X Command Button to your worksheet.

Then in the Sheet Code window select the object Command_Click (left
drop-down)and make it look like this:

Private Sub CommandButton1_Click()
ActiveCell.EntireRow.Insert '<<< Add this
End Sub

Hope this helps,
Jim May


"nadswilkes28" wrote:

I want to creat a button on my spreadsheet then when you click on it you will
automatically insert a row above it.