You could at least narrow it to a particular macro by putting error
traps in each one, for example:

Sub macro1()
' Dim stmts
On Error GoTo ErrorTrap
'other VBA code
Exit Sub
ErrorTrap:
MsgBox ("Error in Macro1")
End Sub

Hth,
Merjet