View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brettjg Brettjg is offline
external usenet poster
 
Posts: 295
Default Error Handling function

I've written a generic error handling Public Function which is in
PERSONAL.xls. Is there a way that I can write just a couple of lines of code
in each workbook to call the function on error? I can't see that a
sheetchange event will work becausse the procedure that crashes may not be
updating a sheet at the time.

Maybe there's a way to get Excel to run the function..........? (i.e by just
changing a setting somewhere)

I don't want to go through all the diferent procedures and insert the code
in because there are far too many of them, but there are only about ten
master workbooks that I cycle through. Regards Brett.