Run macro when the enter key (only) is pressed

Originally Posted by Jeckford

Hi Olly,

I've manage to get yours to work, but how do I call the macro from this point. I removed the "MsgBox "Enter pressed to commit changes"" and replaced it with Call Macro (the macro is called macro) and an error run time appears.

Thanks,

Should work. This does:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Target.Row = ActiveCell.Row Then Call Macro
End Sub

Sub Macro()
    Debug.Print Now, "New row entered"
    'your code here
End Sub

If that's still not working, try attaching your workbook so I can see what's going on.