Public Function to get name of current Macro if it errors

[capson]

Hello,

I can have projects with up to a 100 macros, if somthing errors it can be hard to find the macro that needs attention.

Is their away to write a Public Function to get name of current Macro if it errors?, I have searched but to no avail

Thank you

[mikerickson]

If a macro errors, a dialog opens that allows you to choose between End and Debug. Choosing Debug will take you to the line that caused the error.