View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert Albert is offline
external usenet poster
 
Posts: 203
Default Error location in VBA

Hi!
I have a few users who work with an Excel Addin I created.
For security purposes I have Password-Locked the project so the users can't
access the code.

However, an error arises now and then, and It's hard for me to debug
sometimes because I can't tell where the error occured.

I would like it if when an error arises, insted of showing the "Run-Time
error" dialog, it shows a msgbox displaying a custom message and the location
of the error (Module / Line), but still without opening access to the project
itself.

Is this possible? Any suggestions greatly appreciated.

Best regards,

Albert C.