VBA error - reporting the line of problem code???

[liampog]

Hi

I currently have a VBA project within a sheet that is password-protected so that my users cannot tamper with it.

If there is a problem with the code, it doesn't show the line of code in yellow for obvious reasons that the project is protected.

What I'd like to do is to create a macro that, when there is a problem with the code, it pings off an e-mail to me with the problem line of code in the body of the e-mail.

Is there a function or anything that reports the line of problem code?

I can test it with a MsgBox if necessary.

I don't need any code to send the e-mail as I have that already.

Liam

 

[Derek Brown]

If you are trapping the error (e.g. On Error GoTo) then "Erl()" will give you the line number - but only if you have added line numbers to your code.
MZ Tools add-in will give you that capability.

 

[liampog]

Thanks. I'll have a look.