B
Brettjg
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.
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.