ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Handling function (https://www.excelbanter.com/excel-programming/425312-error-handling-function.html)

Brettjg

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.


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com