Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Error handling with a handling routine | Excel Programming | |||
Error Handling with a Match Function. | Excel Programming | |||
Error Handling Open Function or query for missing Files | Excel Programming | |||
Error handling in vba function | Excel Programming |