If you don't mind use a right-click, you use the worksheet's Before_Rightclick event to insert a new row.
This code will insert a new row only if you are on row-2 (immediately below the header row) and right-click.
Will that work for you?
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
If Target.Row = 2 Then
Cancel = True
Target.EntireRow.Insert shift:=xlDown
End If
End Sub
You must copy the code the code module for the data sheet.
Right click the sheet tab > View Code > copy and paste the code into the sheet module.
Close the VB Editor.
In Excel 2007 you must save the workbook as a .xlsm file type.
Bookmarks