Thread: error handling
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
 
Posts: 122
Default error handling

Hi experts,

I have a workbook with sheets (15), forms (10) and modules (12)

If an error occurs somewhere in the application i would like to:

- get a message stating the part of the application where the error occured
an then
- quit the application without saving

Is this possible or should i go about this in a different way and have an [On
Error Goto] statement with each sub....

Please help / advise me
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1